{"text_format":"1","workbook":"xlsx","n_sheets":29,"sheets":["Help","Common","Checklist A","Checklist B","Master Comment","Departure Port Info","Berth to Pilot","Dep Tide","UKC Restricted at Berth","Dep UKC Restricted 1","Dep Air Draft","Sea Passage","Sea Passage UKC","Implementation","Arrival Port Info","Pilot to Berth","Arrival Tide","Arr UKC Restricted 1","UKC Restricted at Arr Berth","Air Draft","Tide 1","UKC Restricted 1","Air Draft 1","Tide 2","UKC Restricted 2","Air Draft 2","Post Voyage Review","Pick List","Sheet1"],"not_rendered":{"charts":21,"images":22,"macros":1,"external_links":0,"defined_names":150,"comments":18,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Help","index":0,"n_rows":80,"n_cols":6,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"1)      All cells with light yellow are to be filled in."]
[null,"a)      Common data"]
[null,"i)        This data is used for various UKC, squat and overhead clearance."]
[null,"b)      Checklist A"]
[null,"i)        Proof of all charts, documents and navigation info used for the planning of the voyage."]
[null,"c)       Checklist B"]
[null,"i)        Reminders of the requirements to be meet when planning a passage."]
[null,"ii)       Tick required boxes."]
[null,"d)      Master Comments"]
[null,"i)        Any relevant info to be filled in."]
[null,"ii)       If more space is required, this can be added via work document."]
[]
[null,"2)      Departure Port Information"]
[null,"a)      Note “Heel/list”, this is used to calculate your UKC, place the max heel/list you expect on departure of the port."]
[null,"b)      If the UCK is less than 10% a risk assessment is required and confirmation from the officer required. This will calculate automatically."]
[]
[null,"3)      Berth to Pilot"]
[null,"a)      Waypoint numbers will be marked with BP and the number."]
[null,"b)      Place Latitude and Longitude in, this will calculate Course, Distance and DTG."]
[null,"c)       Fix Freq/Method"]
[null,"i)        Frequency and method of fixing must be chosen from drop down list."]
[null,"d)      Watch level must be chosen from drop down list."]
[null,"e)      Extra rows will be added once you add a latitude."]
[]
[null,"4)   Departure Tide Calculation"]
[null,"a)      Ensure you view the comments in the light yellow cell for completing the tab."]
[]
[null,"5)   UKC Restriction at berth"]
[null,"a)      Ensure that you do complete all light yellow cells."]
[]
[null,"6)   UKC Restriction at critical location.",null,null,null,"(The value of channel width is not to be entered more than 270 meters, if channel width is lesser, enter actual value)"]
[null,"a)      This is to be used for the shallowest depth on the passage from the berth to pilot station. This must be placed on this tab as it links to the Departure Port Info tab."]
[null,"b)      If there is more than one critical location, you need to great extra sheets."]
[]
[null,"7)   Departure Air draft (Overhead Clearance)"]
[null,"a)      Is only to be used if there is an overhead restriction."]
[]
[null,"8)   Sea Passage Waypoints"]
[null,"a)      Waypoint numbers must be marked with WP and the number."]
[null,"b)      Place Latitude and Longitude in, this will calculate Course, Distance and DTG."]
[null,"c)       Fix Freq/Method"]
[null,"i)        Frequency and method of fixing must be chosen from drop down list."]
[null,"d)      Watch level must be chosen from drop down list."]
[null,"e)      Extra rows will be added once you add a latitude."]
[null,"f)     WP will automatically update once you complete Geographical Area Waypoint"]
[]
[null,"9)   Sea Passage UKC",null,null,"(The value of channel width is not to be entered more than 270 meters, for open waters enter channel width 270 meters)"]
[null,"a)      This is to be done for the shallowest point from Pilot to Pilot."]
[]
[null,"10)   Implementation"]
[null,"a)      This is to be used during the voyage; to ensure that all 9 items are covered for each chart were required."]
[null,"b)      This is to be filled out by the officer on watch using the chart at the time."]
[null,"c)       BTM stands for Bridge Team Management."]
[]
[null,"11)   Pilot to berth section of the plan is to be carried out as per departure layout above."]
[]
[null,"12)   Extra tabs for UKC and Air draft have been added, so if we required can be completed."]
[]
[null,"Printing"]
[null,"1)      Following is to be printed and filled in 1.3.1A Binder for each voyage."]
[null,"a)      Check list A"]
[null,"b)      Checklist B"]
[null,"c)       Master Comments"]
[null,"d)      Departure Port Info"]
[null,"e)      Berth to Pilot waypoints"]
[null,"f)       Departure tide calculation"]
[null,"g)      UKC restriction at berth"]
[null,"h)      UKC restriction at shallowest point on passage."]
[null,"i)        Departure Air Draft (if required due)"]
[null,"j)        Sea passage waypoints"]
[null,"k)      Sea passage UKC for shallowest point in voyage."]
[null,"l)        Implementation form"]
[null,"m)    Arrival port information"]
[null,"n)      Pilot to berth waypoints"]
[null,"o)      Tidal calculation"]
[null,"p)      Arrival UKC restriction enroute to berth"]
[null,"q)      UKC for berth."]
[null,"r)       Air draft calculation (if required due)"]

{"sheet":"Common","index":1,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,1,1,3],[2,1,3,3],[4,1,5,3]]}
[null,"HEALTH, SAFETY,  ENVIRONMENT AND QUALITY MANAGEMENT SYSTEM"]
[null,null,null,null,"Form","1.3.1"]
[null,"PASSAGE PLAN - DETAILS",null,null,"Date:","08-Aug-2025"]
[null,null,null,null,"Rev No.","10.1"]
[null,"REPORTING  FORMS  MANUAL",null,null,"Appr:","DPA"]
[null,null,null,null,"File No.","1.3"]
[]
[null,"Date"]
[]
[null,"Vessel Name"]
[null,"Call Sign :"]
[null,"Voyage No"]
[null,"Ballast / Partly Loaded/ Loaded :"]
[]
[null,"From"]
[null,"Berth"]
[null,"GMT :"]
[]
[null,"To"]
[null,"Berth"]
[null,"GMT :"]
[]
[null,"Via"]
[null,"GMT :"]
[]
[null,"Draft F"]
[null,"Draft Mid",{"$f":"+(C26+C28)/2","v":0}]
[null,"Draft A"]
[null,"Trim",{"$f":"C28-C26","v":0}]
[null,"Cb @"]
[]
[]
[null,"Moulded Breadth"]
[]
[null,"LBP (Between Perpendiculars)"]
[null,"Keel to Max. Hight Mast"]
[null,"Air Draft",{"$f":"C36-C28","v":0}]
[null,"Dist. APP to Highest Point Mast"]
[]
[null,"Draft in the Highest Point Mast",{"$f":"IF(C35=0,0,(C28-(C38*(SIN(((TANH(C29/C35))/(PI()/180))*(PI()/180))))))","v":0}]
[]
[]
[null,"Speed Variables"]
[1,"Full Ahead",null,"knots"]
[2,"Half Ahead",null,"knots"]
[3,"Slow Ahead",null,"knots"]
[4,"Dead Slow Ahead",null,"knots"]

{"sheet":"Checklist A","index":2,"n_rows":64,"n_cols":28,"rows_kept":64,"cut":false,"hidden":false,"merged":[[55,0,55,13],[55,14,55,15],[54,0,54,15],[53,0,53,15],[59,4,59,8],[59,9,59,12],[59,13,59,15],[0,2,1,13],[2,2,3,13],[4,2,5,13],[12,1,12,2],[13,1,13,2],[12,11,12,12],[10,11,10,12],[13,11,13,12],[6,0,6,15],[8,4,8,6],[8,7,8,9],[10,14,10,15],[11,7,11,10],[11,11,11,12],[8,1,8,2],[11,1,11,2],[12,7,12,10],[13,7,13,10],[14,1,14,2],[17,9,17,10],[14,5,14,8],[15,17,17,23],[17,1,17,3],[39,1,39,7],[22,3,22,8],[23,3,23,8],[24,3,24,8],[16,9,16,10],[15,1,15,2],[14,9,14,10],[18,0,18,8],[18,11,18,15],[28,0,28,2],[26,12,26,15],[25,0,25,2],[26,0,26,2],[27,0,27,2],[24,0,24,2],[22,0,22,2],[23,0,23,2],[20,0,20,2],[41,3,41,6],[41,7,41,15],[15,5,15,8],[16,5,16,8],[43,1,43,2],[44,1,44,2],[43,3,43,6],[43,7,43,15],[41,1,41,2],[21,0,21,2],[19,0,19,2],[19,3,19,8],[20,3,20,8],[21,3,21,8],[42,1,42,2],[42,3,42,6],[42,7,42,15],[32,14,32,15],[25,3,25,8],[26,3,26,8],[27,3,27,8],[28,3,28,8],[32,1,32,8],[15,9,15,10],[58,1,58,15],[10,0,10,2],[50,0,50,15],[52,0,52,15],[56,14,56,15],[33,1,33,8],[33,14,33,15],[34,1,34,8],[34,14,34,15],[35,1,35,8],[35,14,35,15],[29,0,29,8],[31,0,31,8],[31,10,31,12],[31,14,31,15],[44,3,44,6],[38,1,38,8],[37,14,37,15],[38,14,38,15],[36,1,36,8],[36,14,36,15],[37,1,37,8],[44,7,44,15],[49,0,49,15],[60,1,60,3],[60,4,60,8],[60,9,60,12],[60,13,60,15],[62,7,62,8],[63,7,63,8],[61,11,61,12],[62,11,62,12],[63,11,63,12],[61,14,61,15],[62,14,62,15],[63,14,63,15]]}
[null,null,"HEALTH, SAFETY,  ENVIRONMENT AND QUALITY MANAGEMENT SYSTEM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,"PASSAGE PLAN - CHECKLIST A",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E6","v":"File No."},{"$f":"Common!F6","v":"1.3"}]
[]
[]
["Date :",{"$f":"IF(Common!C8=\"\",\"\",Common!C8)","v":""},null,null,"Vessel Name :",null,null,{"$f":"IF(Common!C10=\"\",\"\",Common!C10)","v":""},null,null,null,null,null,null,"Voyage No :",{"$f":"IF(Common!C12=\"\",\"\",Common!C12)","v":""}]
[]
["Draft",null,null,null,null,null,null,"Port",null,null,null,"Berth",null,null,"Time"]
["Fwd :",{"$f":"Common!C26","v":0},null,null,null,null,"From :",{"$f":"IF(Common!C15=\"\",\"\",Common!C15)","v":""},null,null,null,{"$f":"IF(Common!C16=\"\",\"\",Common!C16)","v":""},null,null,"GMT :",{"$f":"IF(Common!C17=\"\",\"\",Common!C17)","v":""}]
["Mid :",{"$f":"Common!C27","v":0},null,null,null,null,"To :",{"$f":"IF(Common!C19=\"\",\"\",Common!C19)","v":""},null,null,null,{"$f":"IF(Common!C20=\"\",\"\",Common!C20)","v":""},null,null,"GMT :",{"$f":"IF(Common!C21=\"\",\"\",Common!C21)","v":""}]
["Aft :",{"$f":"Common!C28","v":0},null,null,null,null,"Via :",{"$f":"IF(Common!C23=\"\",\"\",Common!C23)","v":""},null,null,null,null,null,null,"GMT :",{"$f":"IF(Common!C24=\"\",\"\",Common!C24)","v":""}]
["Trim :",{"$f":"B14-B12","v":0},null,null,null,"Distance Berth - Pilot",null,null,null,{"$f":"'Berth to Pilot'!S8","v":0},null,"Passage Berth - Pilot",null,{"$f":"IF(P15=0,0,J15/(P15*24))","v":"00:00:00"},"Av. Speed"]
["Air Draft:",{"$f":"Common!C37","v":0},null,null,null,"Distance Pilot to Pilot ",null,null,null,{"$f":"'Sea Passage'!S9","v":0},null,"Passage Polit - Pilot",null,{"$f":"IF(P16=0,0,J16/(P16*24))","v":"00:00:00"},"Av. Speed"]
[null,null,null,null,null,"Distance Pilot to Berth",null,null,null,{"$f":"'Pilot to Berth'!S9","v":0},null,"Passage Pilot - Berth",null,"00:00:00","Av. Speed"]
[null,null,null,null,null,"Distance Total",null,null,null,{"$f":"SUM(J15:K17)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Charts: "]
["Coast Pilot Books"]
["Admiralty List of Radio Signals"]
["Admiralty List of Lights"]
["Admiralty Tide Tables"]
["Tidal Stream Atlas"]
["Mariner's Handbook"]
["Routeing Charts"]
["Reporting *",null,null,"See enclosed forms",null,null,null,null,null,null,"Reference Charts : "]
[]
[]
["* Procedures on chart & bridge note book",null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[]
["NAVIGATIONAL AIDS",null,null,null,null,null,null,null,null,null,"STEAMING TIME Pilot to Pilot",null,null,null,"NAVTEX"]
["A",null,null,null,null,null,null,null,null,null,"Knots","Days","Hours"]
["B",null,null,null,null,null,null,null,null,null,{"$f":"K35-0.5","v":-1.5},{"$f":"AB34","v":0},{"$f":"AA34","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$J$16/K34","v":0},{"$f":"MOD(Z34,24)","v":0},{"$f":"(Z34-AA34)/24","v":0}]
["C",null,null,null,null,null,null,null,null,null,{"$f":"K36-0.5","v":-1},0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$J$16/K35","v":0},0,0]
["D",null,null,null,null,null,null,null,null,null,{"$f":"K37-0.5","v":-0.5},0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$J$16/K36","v":0},0,0]
["E",null,null,null,null,null,null,null,null,null,{"$f":"Common!C44","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K37=0,0,$J$16/K37)","v":0},0,0]
["F",null,null,null,null,null,null,null,null,null,{"$f":"K37+0.5","v":0.5},0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["G",null,null,null,null,null,null,null,null,null,{"$f":"K38+0.5","v":1},0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$J$16/K39","v":0},0,0]
["H","TOTAL TIDE USED FOR UKC CALCULATIONS? (Y/N)",null,null,null,null,null,null,"YES"]
[]
[null,"NAVAREA",null,"WARNING",null,null,null,"CHART AFFECTED"]
[]
[]
[]
[]
["MASTER'S DECLARATION"]
["This is to declare that "]
["A. Company's Minimum Requirement regarding the Under Keel Clearance can be complied with "]
["Fleet Management MUST be advised immediately in case company’s minimum requirements regarding UKC can not be complied with OR in case UKC can not be determined due to lack of information from Charterers"]
["Prior arrival, Masters must request local agents to provide information relating to prevailing weather conditions which may have an impact on safe navigation. (e.g. Strong winds for an extended period of time which could effect depth of water in port, Currents or any other conditions which could have a negative effect)"]
["B. Company's Minimum Requirement regarding the Rest Hours can be complied with"]
["(Fleet Management MUST be advised immediately in case Company’s / STCW  minimum requirements regarding Rest Hours cannot be complied with)"]
["C. up-to-date certificates and documents concerning the vessel, its equipment, crew, passengers or cargo are onboard. "]
["D. Chief engineer consulted and sufficient quantities of bunkers and fresh water (plus a safe margin of reserve) , food /provisions , lubricants, chemicals, expendable and other spare parts, tools, supplies etc available on board for the anticipated voyage."]
["E. Vessel will comply with Loadline requirements and will trade only within the International Navigation Limits thoughout the voyage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Master"]
[null,"Master's Comment"]
[]
[null,"Prepared by:",null,null,"Reviewed and Acknowledged by:",null,null,null,null,"Reviewed and Acknowledged by:",null,null,null,"Reviewed and Acknowledged by:"]
[]
[null,"Signature:",null,null,"Signature:",null,null,null,null,"Signature:",null,null,null,"Signature:"]
[null,"Nav. Off:",null,null,"3rd Officer :",null,null,null,null,"CNO :",null,null,null,"Master :"]
[null,"Date: ",null,null,"Date:",null,null,null,null,"Date: ",null,null,null,"Date:"]

{"sheet":"Checklist B","index":3,"n_rows":84,"n_cols":7,"rows_kept":84,"cut":false,"hidden":false,"merged":[[58,1,58,2],[63,1,63,2],[60,4,60,6],[66,0,66,6],[64,4,64,6],[61,4,61,6],[60,1,60,2],[61,1,61,2],[65,1,65,2],[65,4,65,6],[64,1,64,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[19,4,19,6],[17,4,17,6],[18,4,18,6],[38,1,38,6],[39,1,39,6],[36,1,36,6],[34,1,34,4],[0,2,1,4],[2,2,3,4],[4,2,5,4],[7,0,7,6],[14,4,14,6],[9,4,9,6],[35,0,35,6],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[40,0,40,4],[8,0,8,4],[20,0,20,4],[33,0,33,4],[24,1,24,2],[24,4,24,6],[22,4,22,6],[32,1,32,4],[10,1,10,2],[10,4,10,6],[22,1,22,2],[37,1,37,6],[9,1,9,2],[11,4,11,6],[16,4,16,6],[15,4,15,6],[81,1,81,6],[82,1,82,6],[83,1,83,6],[74,1,74,6],[75,1,75,6],[76,1,76,6],[78,1,78,6],[79,1,79,6],[77,1,77,6],[51,1,51,2],[52,4,52,6],[80,1,80,6],[62,4,62,6],[53,1,53,2],[54,1,54,2],[53,4,53,6],[54,4,54,6],[57,4,57,6],[51,4,51,6],[67,1,67,6],[55,1,55,2],[57,1,57,2],[59,1,59,2],[58,4,58,6],[59,4,59,6],[13,4,13,6],[12,4,12,6],[73,1,73,6],[68,1,68,6],[71,1,71,6],[69,1,69,6],[72,1,72,6],[70,1,70,6],[46,0,46,4],[55,4,55,6],[63,4,63,6],[62,1,62,2],[56,4,56,6],[52,1,52,2],[50,0,50,4],[56,1,56,2]]}
[null,null,"HEALTH, SAFETY,  ENVIRONMENT AND QUALITY MANAGEMENT SYSTEM"]
[null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,"PASSAGE PLAN - CHECKLIST B",null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,"SHIP REPORTING  FORMS  MANUAL",null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[null,null,null,null,null,{"$f":"Common!E6","v":"File No."},{"$f":"Common!F6","v":"1.3"}]
["Passage Plan Appraisal & Checklist also considering SOLAS Chapter V, Reg. 34"]
["Appraisal & planning of passage to be done using information from relevant sources. Suggested sources are listed below. Click mouse on item to place Ö in boxes to left of items used in appraisal and planning."]
["Appraisal"]
[null,"Adequacy and reliability of aids to navigation",null,null,"Adequacy and reliability of charts and hydrographic data"]
[null,"Appropriate scale charts for ocean, coastal, harbour and berthing phases",null,null,"New charts and licences ordered as appropriate"]
[null,"Port entry information",null,null,"Port security advisories"]
[null,"Local area warnings",null,null,"NAVAREA navigational warnings"]
[null,"Notices to Mariners / T&P Notices",null,null,"Destination country Flag available"]
[null,"List of lights and radio signals",null,null,"Routeing information and load line charts"]
[null,"Sailing directions and pilot books",null,null,"Tidal tables and tidal stream atlases"]
[null,"Traffic's flow/type/volume",null,null,"Charterer/Company instructions"]
[null,"IMO Ship's Routeing / TSS",null,null,"Mariners Handbook / Ocean Passages"]
[null,"Last voyage review"]
[null,"Razor Wire / spikes on board if vessel intends to transit HRA/VRA",null,null,"International Navigation Limits (INL) referred to and vessel within INL (Refer Memo / Insurance Section for INL)  "]
["Passage Requirements"]
[null,"Anchoring locations",null,null,"Routeing, reporting measures and VTS"]
[null,"Any special ship operational requirement for the passage",null,null,"Draught restrictions including air draught and UKC requirements"]
[null,"Bunker calculations",null,null,"Security concerns"]
[null,"Cargo (including hazardous types) and special stowage/carriage/securing restrictions",null,null,"Communications/GMDSS watchkeeping considerations"]
[null,"Helicopter operations",null,null,"Safety contours"]
[null,"Load line requirements",null,null,"Safety depths"]
[null,"Log book requirements",null,null,"Ship-to-ship transfers"]
[null,"Passage reporting requirements",null,null,"Strength and stability"]
[null,"Passage speed and ETA calculations",null,null,"Watch schedules"]
[null,"Position fixing intervals",null,null,"Area where E/R should be in readiness"]
[null,"Squat / Ship's Manoeuvring data",null,null,"Areas requiring additional sea room"]
[null,"Reliability of propulsion and steering systems or any known defects affecting navigation or control of vessel including operational limitations"]
["Charts and Publications corrections"]
[null,"All Charts/ENC and Publications are corrected to NTM to WK ______ ___________"]
["Environmental Considerations  (SOLAS Chapter V, Reg. 34). To be marked on charts"]
[null,"Ballast Water exchange / treatment requirements"]
[null,"Emission Control Area (ECA) limits and fuel changeover procedures, EU directive"]
[null,"MARPOL Special Areas, PSSAs, or national and regional requirements"]
[null,"Notifications/advise to crew on board (Mark positions of No discharge of sewage / garbage / oil or oily mixtures / cargo hold washing etc as applicable for the voyage)."]
["Weather / Conditions"]
[null,"Abnormal waves",null,null,"Tropical storms"]
[null,"Currents and tides",null,null,"Visibility"]
[null,"Heavy weather",null,null,"Weather routeing"]
[null,"Ice",null,null,"Winds"]
[null,"Swell"]
["Contingencies"]
[null,"Emergency anchorages",null,null,"Notifications and reporting"]
[null,"Emergency response plans",null,null,"Plan amendments"]
[]
["Have the following been marked on ECDIS ?"]
[null,"Parallel Index Lines / Cross index range",null,null,"Wheel over Position"]
[null,"Points where accurate position fixing is critical",null,null,"Clearing Lines & bearings"]
[null,"Methods & frequency of position fixing",null,null,"Transits, heading marks & leading lines"]
[null,"No-Go Areas / cross track margin",null,null,"Significant tides & current"]
[null,"Landfall targets and Lights",null,null,"Safe speed & necessary speed alterations"]
[null,"Position where echo sounder would be activated",null,null,"Changes in machinery status/Engine Room and change over from auto to manual steering"]
[null,"Anchor clearance",null,null,"Status of Bridge Watch Level"]
[null,"Abort Position ( Port / Channel / Berth Approach ) and point of no return",null,null,"Crossing and High traffic density areas"]
[null,"T & P Corrections / Nav Warnings",null,null,"Environmental Sensitive Area"]
[null,"Prominent navigation and radar marks",null,null,"Minimum UKC"]
[null,"Safe distance off danger points",null,null,"Air draft when passing bridge/cables"]
[null,"Calling Master/operational notes",null,null,"VTS / Reporting points / Mandatory & Voluntary ship reproting system like SISTRAM / AMVER / JASPER etc"]
[null,"Vessel Contingency Plans & contingency Anchoring area ",null,null,"Speed reduction to less than 10 kts in Right Whale Area"]
[null,"HRA/VRA marked on ECDIS (User Chart) and screenshot sent to company",null,null,"Position where vessel is to hardened (i.g: razor wires etc)"]
[null,"Changes to security levels (Level 1/2/3)",null,null,"Changes in bridge manning levels (e.g: extra lookouts)"]
["Have the following checks carried out on ECDIS?"]
[null,"Confirm Primary and secondary ECDIS are operational"]
[null,"Check ENC permits for entire voyage are available"]
[null,"Has a ECDIS Passage Plan for the intended voyage been prepared?"]
[null,"Has safety Check for the ECDIS voyage route carried out and route put on  monitoring?"]
[null,"Check entire passage plan from berth to berth on a 1:1 scale by manually scrolling along the track"]
[null,"Voyage plan independently checked by another qualified deck officer"]
[null," Has the Master reviewed and approved the plan?"]
[null,"Are all charts and ENC’s for the intended voyage and other Nautical Publications up to date "]
[null,"Are latest ECDIS charts (ENC/ARCS) available on both primary and secondary ECDIS "]
[null,"Check Safety Depth and Shallow contour setting value have been applied as per company UKC"]
[null,"An appropriate value of cross track distance (XTD) has been applied"]
[null,"Appropriate area layers selected for ENC Chart in Chart settings"]
[null,"All area alarm are active on the ECDIS in the Alarm settings"]
[null,"Has sensor (i.e. GPS, Gyro & Speed) inputs to the ECDIS verified for data accuracy with respective equipment?"]
[null,"Have the latest navigational and Navtex warnings for the area received and same plotted on ENC? "]
[null,"Check area where RCDS mode will be operated, whether appropriate paper charts are on board"]
[null,"Approved Voyage Plan to be loaded and synchronised on both ECDIS terminals."]

{"sheet":"Master Comment","index":4,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[43,1,43,3],[44,1,44,3],[25,0,41,8],[8,0,8,8],[0,1,1,6],[2,1,3,6],[4,1,5,6],[9,0,23,8],[7,0,7,8],[24,0,24,8]]}
[null,"HEALTH, SAFETY,  ENVIRONMENT AND QUALITY MANAGEMENT SYSTEM"]
[null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,"PASSAGE PLAN - MASTERS COMMENTS",null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[null,null,null,null,null,null,null,{"$f":"Common!E6","v":"File No."},{"$f":"Common!F6","v":"1.3"}]
[]
["Additional Remarks - Including Deviation from Planned route"]
["( Please enter remarks regarding anticipated Ocean currents, Visibility & Other Meterological Conditions; Areas of high traffic density ; Ship operations which may require additional searoom e.g tank cleaning or pilot embarkation ; the availability and reliability of navigation aids, marks lights and radar consipicous objects etc )\nDeviation from planned route : Please provide additional comments or remarks\n( for example reporting of ice,  avoiding heavy weather, avoiding unexpected cluster of fishing vessels that may take the vessel out of the navigable corridor, change of port of destination,  medical emergency, new route proposed by the pilot, navigation warnings received like firing exercise or other navigational hazards, avoiding high risk area  etc.) "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Master's Comments"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Master :"]
["Signature :"]

{"sheet":"Departure Port Info","index":5,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[15,2,15,3],[38,0,38,6],[40,0,40,6],[14,2,14,6],[33,2,33,6],[34,2,34,6],[35,2,35,6],[36,2,36,6],[32,5,32,6],[16,0,16,1],[17,0,17,1],[20,0,20,6],[31,5,31,6],[35,0,35,1],[36,0,36,1],[23,0,23,1],[12,0,12,6],[0,1,1,4],[2,1,3,4],[4,1,5,4],[8,0,8,1],[9,0,9,1],[6,5,6,6],[7,0,7,6],[26,0,26,1],[27,0,27,1],[33,0,33,1],[34,0,34,1],[21,0,21,1],[22,0,22,1],[24,0,24,1],[18,0,18,1],[19,0,19,1],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[13,2,13,6],[10,0,10,1],[11,0,11,1],[13,0,13,1],[14,0,14,1],[15,0,15,1]]}
[null,"HEALTH, SAFETY,  ENVIRONMENT AND QUALITY MANAGEMENT SYSTEM"]
[null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,"PASSAGE PLAN - DEPARTURE PORT INFO",null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[null,null,null,null,null,{"$f":"Common!E6","v":"File No."},{"$f":"Common!F6","v":"1.3"}]
[]
["PORT OF DEPARTURE INFORMATION"]
["Name of Departure Berth"]
["VHF Channel(s) - Port Control"]
["VHF Channel(s) - VTS"]
["VHF Channel(s) - Pilots"]
["Tidal Information"]
["Standard Port"]
["Date"]
[null,null,"TIME ",null,"HEIGHT"]
["High Water",null,null,null,null,"Mtrs"]
["Low Water",null,null,null,null,{"$f":"$F$17","v":"Mtrs"}]
["High Water",null,null,null,null,{"$f":"$F$17","v":"Mtrs"}]
["Low Water",null,null,null,null,{"$f":"$F$17","v":"Mtrs"}]
["Estimated Draft on Departure"]
["Forward",null,{"$f":"Common!C26","v":0},null,"Mtrs"]
["Aft",null,{"$f":"Common!C28","v":0},null,"Mtrs"]
["Mean",null,{"$f":"(C22+C23)/2","v":0},null,"Mtrs"]
["Vessel’s Maximum Air-draft",null,{"$f":"Common!C36-'Departure Port Info'!C23","v":0},null,"Mtrs"]
["Heel/List",null,null,null,{"$f":"TAN(RADIANS(C26))*Common!C33/2","v":0},"Mtrs"]
["Distance - Berth to Pilot Station",null,{"$f":"'Berth to Pilot'!S8","v":0}]
["Estimated Time to Pilot Station",null,{"$f":"'Checklist A'!N15","v":"00:00:00"},null,"Is there an overhead obstruction:"]
[null,null,"Restricted 1","Berth"]
[null,{"$f":"IF(G28=\"No\",\"\",\"Overhead Cleance\")","v":"Overhead Cleance"},{"$f":"IF(G28=\"No\", \" \",'Dep Air Draft'!J38)","v":0},"n/a"]
[null,"Minium UKC",{"$f":"'Dep UKC Restricted 1'!J38","v":0},{"$f":"'UKC Restricted at Berth'!J39","v":0}]
[null,"Maximum Squat",{"$f":"'Dep UKC Restricted 1'!G31","v":0},{"$f":"'UKC Restricted at Berth'!G32","v":0},{"$f":"C29","v":"Restricted 1"},{"$f":"D29","v":"Berth"}]
[null,"UKC (Deepest draft + squat)",{"$f":"'Dep UKC Restricted 1'!L38","v":0},{"$f":"'UKC Restricted at Berth'!L39","v":0},{"$f":"IF(C33<10,\"Risk Assessment required!\",\"\")","v":"Risk Assessment required!"},{"$f":"IF(D33<10,\"Risk Assessment required!\",\"\")","v":"Risk Assessment required!"}]
["Is There a Change of Pilots?"]
["If Yes, Where"]
["Number of Tugs"]
["Location Tugs will Leave Vessel"]
["Remarks: (General route, channel to use, special precaution, etc)"]
[]
["Prevailing Current / Weather Information "]

{"sheet":"Berth to Pilot","index":6,"n_rows":33,"n_cols":83,"rows_kept":33,"cut":false,"hidden":false,"merged":[[9,7,9,12],[7,7,7,9],[8,6,8,9],[8,12,8,14],[6,1,6,2],[8,1,8,2],[10,9,12,9],[10,12,11,15],[10,19,12,20],[32,5,32,7],[10,0,12,0],[10,1,12,1],[10,2,11,4],[10,5,11,7],[5,2,5,18],[0,2,0,18],[1,2,1,18],[2,2,2,18],[3,2,3,18],[4,2,4,18]]}
[null,null,"HEALTH, SAFETY, ENVIRONMENT AND QUALITY MANAGEMENT SYSTEM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,"WAYPOINT LIST - BERTH TO PILOT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,"REPORTING FORMS MANUAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E6","v":"File No."},{"$f":"Common!F6","v":"1.3"}]
[null,"All dates & times are GMT"]
[null,"PILOTS",null,"SPD"," ","Voy :",{"$f":"IF(Common!C11=\"\",\"\",Common!C11)","v":""},{"$f":"IF(Common!C13=\"\",\"\",Common!C13)","v":""},null,null,"Time",null,null,null,null,null,null,null,{"$f":"BPSum1","v":0}]
[null,null,null,null," ","From :",{"$f":"'Checklist A'!$H$12","v":""},null,null,null,{"$f":"IF(Common!C17=\"\",\"\",Common!C17)","v":""},"To :",{"$f":"'Checklist A'!$H$13","v":""},null,null,{"$f":"IF(Common!C21=\"\",\"\",Common!C21)","v":""},null,null,"Berth to Pilot"]
[null,null,null," "," "," "]
["WP No.","GEOGRAPHICAL AREA WAYPOINT","LATITUDE",null,null,"LONGITUDE",null,null,null,"DIST. TO NEXT WP",null,null,"Fix / Ver Freq / Method",null,null,null,null,null,"Remarks: NAV Aids, Restrictions, Weather,","Watch Level"]
[null,null,null,null,null,null,null,null,"CO",null,"DTG","RL/GC",null,null,null,null,"Max","T&P","Cautions, Traffic Density, UKC, Tides, Abort point etc",null,null,null,"latrad","longrad","dlon_W","dlon_E","dphi","q1","q","dlon_min","tc_rad","tc","dist_rad","dist"]
[null,null,"DEG","MIN","N/S","DEG","MIN","E/W",null,null,null,null,"Freq","Main","Alt 1","Alt 2","Spd","Notices","T&P notice number effecting each leg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Course","Distance"]
["BP 1",null,null,null,null,null,null,null,{"$f":"IF(C15=\"\",\"\",IF(Z14<Y14,360-AF14,AF14))","v":""},{"$f":"IF(C15=\"\",0,+AH14)","v":0},{"$f":"+J33","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E14=\"N\",RADIANS(C14+(D14/60)),-RADIANS(C14+(D14/60)))","v":0},{"$f":"IF(H14=\"E\",+RADIANS(F14+(G14/60)),-RADIANS(F14+(G14/60)))","v":0},{"$f":"MOD(X15-X14,2*PI())","v":0},{"$f":"MOD(X14-X15,2*PI())","v":0},{"$f":"LN(TAN(W15/2+PI()/4)/TAN(W14/2+PI()/4))","v":0},{"$f":"COS(W14)","v":1},{"$f":"IF(W15=W14,AB14,(W15-W14)/AA14)","v":1},{"$f":"MIN(Y14,Z14)","v":0},{"$f":"MOD(ATAN2(AA14,AD14),2*PI())","v":{"$error":"#DIV/0!"}},{"$f":"DEGREES(AE14)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(AC14^2*AD14^2+(W15-W14)^2)","v":0},{"$f":"DEGREES(AG14)*60","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I14","v":""},{"$f":"J14","v":0}]
["BP 2",null,null,null,null,null,null,null,"",0,{"$f":"+K14-J14","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"MOD(X16-X15,2*PI())","v":0},{"$f":"MOD(X15-X16,2*PI())","v":0},{"$f":"LN(TAN(W16/2+PI()/4)/TAN(W15/2+PI()/4))","v":0},{"$f":"COS(W15)","v":1},{"$f":"IF(W16=W15,AB15,(W16-W15)/AA15)","v":1},{"$f":"MIN(Y15,Z15)","v":0},{"$f":"MOD(ATAN2(AA15,AD15),2*PI())","v":{"$error":"#DIV/0!"}},{"$f":"DEGREES(AE15)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(AC15^2*AD15^2+(W16-W15)^2)","v":0},{"$f":"DEGREES(AG15)*60","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["BP 3",null,null,null,null,null,null,null,"",0,{"$f":"+K15-J15","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"MOD(X17-X16,2*PI())","v":0},{"$f":"MOD(X16-X17,2*PI())","v":0},{"$f":"LN(TAN(W17/2+PI()/4)/TAN(W16/2+PI()/4))","v":0},1,{"$f":"IF(W17=W16,AB16,(W17-W16)/AA16)","v":1},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SQRT(AC16^2*AD16^2+(W17-W16)^2)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["BP 4",null,null,null,null,null,null,null,"",0,{"$f":"+K16-J16","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["BP 5",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["BP 6",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["BP 7",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["BP 8",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"MOD(X22-X21,2*PI())","v":0},{"$f":"MOD(X21-X22,2*PI())","v":0},{"$f":"LN(TAN(W22/2+PI()/4)/TAN(W21/2+PI()/4))","v":0},1,{"$f":"IF(W22=W21,AB21,(W22-W21)/AA21)","v":1},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SQRT(AC21^2*AD21^2+(W22-W21)^2)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["BP 9",null,null,null,null,null,null,null,"",0,{"$f":"+K21-J21","v":0},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["BP 10",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["BP 11",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["BP 12",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["BP 13",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["BP 14",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["BP 15",null,null,null,null,null,null,null,{"$f":"IF(C29=\"\",\"\",IF(Z28<Y28,360-AF28,AF28))","v":""},{"$f":"IF(C29=\"\",0,+AH28)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"MOD(X29-X28,2*PI())","v":0},{"$f":"MOD(X28-X29,2*PI())","v":0},{"$f":"LN(TAN(W29/2+PI()/4)/TAN(W28/2+PI()/4))","v":0},1,{"$f":"IF(W29=W28,AB28,(W29-W28)/AA28)","v":1},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SQRT(AC28^2*AD28^2+(W29-W28)^2)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["BP 16",null,null,null,null,null,null,null,{"$f":"IF(C30=\"\",\"\",IF(Z29<Y29,360-AF29,AF29))","v":""},{"$f":"IF(C30=\"\",0,+AH29)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"MOD(X30-X29,2*PI())","v":0},{"$f":"MOD(X29-X30,2*PI())","v":0},{"$f":"LN(TAN(W30/2+PI()/4)/TAN(W29/2+PI()/4))","v":0},1,{"$f":"IF(W30=W29,AB29,(W30-W29)/AA29)","v":1},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SQRT(AC29^2*AD29^2+(W30-W29)^2)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["BP 17",null,null,null,null,null,null,null,{"$f":"IF(C31=\"\",\"\",IF(Z30<Y30,360-AF30,AF30))","v":""},{"$f":"IF(C31=\"\",0,+AH30)","v":0},{"$f":"+K29-J29","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E30=\"N\",RADIANS(C30+(D30/60)),-RADIANS(C30+(D30/60)))","v":0},{"$f":"IF(H30=\"E\",+RADIANS(F30+(G30/60)),-RADIANS(F30+(G30/60)))","v":0},{"$f":"MOD(X31-X30,2*PI())","v":0},{"$f":"MOD(X30-X31,2*PI())","v":0},{"$f":"LN(TAN(W31/2+PI()/4)/TAN(W30/2+PI()/4))","v":0},{"$f":"COS(W30)","v":1},{"$f":"IF(W31=W30,AB30,(W31-W30)/AA30)","v":1},{"$f":"MIN(Y30,Z30)","v":0},{"$f":"MOD(ATAN2(AA30,AD30),2*PI())","v":{"$error":"#DIV/0!"}},{"$f":"DEGREES(AE30)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(AC30^2*AD30^2+(W31-W30)^2)","v":0},{"$f":"DEGREES(AG30)*60","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I30","v":""}]
["BP 18",null,null,null,null,null,null,null,{"$f":"IF(C32=\"\",\"\",IF(Z31<Y31,360-AF31,AF31))","v":""},{"$f":"IF(C32=\"\",0,+AH31)","v":0},{"$f":"+K30-J30","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E31=\"N\",RADIANS(C31+(D31/60)),-RADIANS(C31+(D31/60)))","v":0},{"$f":"IF(H31=\"E\",+RADIANS(F31+(G31/60)),-RADIANS(F31+(G31/60)))","v":0},{"$f":"MOD(X32-X31,2*PI())","v":0},{"$f":"MOD(X31-X32,2*PI())","v":0},{"$f":"LN(TAN(W32/2+PI()/4)/TAN(W31/2+PI()/4))","v":0},{"$f":"COS(W31)","v":1},{"$f":"IF(W32=W31,AB31,(W32-W31)/AA31)","v":1},{"$f":"MIN(Y31,Z31)","v":0},{"$f":"MOD(ATAN2(AA31,AD31),2*PI())","v":{"$error":"#DIV/0!"}},{"$f":"DEGREES(AE31)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(AC31^2*AD31^2+(W32-W31)^2)","v":0},{"$f":"DEGREES(AG31)*60","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I31","v":""}]
[]
[" ",null," "," "," ","TOTAL DISTANCE:",null,null,null,{"$f":"SUM(J15:J32)","v":0},null," ",null,null,null,null,null,null,null,null,null,null," "," "," "," "," "," ",null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," ",null," "," "]

{"sheet":"Dep Tide","index":7,"n_rows":77,"n_cols":79,"rows_kept":77,"cut":false,"hidden":false,"merged":[[1,3,2,9],[3,3,4,9],[1,11,1,12],[2,11,2,12],[4,11,4,12],[3,11,3,12],[75,42,75,44],[25,9,25,10],[9,8,9,10],[22,5,22,7],[9,3,9,6],[10,3,10,6],[14,5,14,7],[19,5,19,7],[11,3,11,6],[5,11,5,12],[6,11,6,12],[6,3,6,9],[17,5,17,7],[74,42,74,44]]}
[]
[null,null,null,"HEALTH, SAFETY,  ENVIRONMENT AND QUALITY MANAGEMENT SYSTEM"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,null,"SIMPLIFIED TIDE CALCULATION",null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[null,null,null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,null,null,null,{"$f":"Common!E6","v":"File No."},{"$f":"Common!F6","v":"1.3"}]
[]
[null,null,null,null,null,null,null,null,"YYYY-MM-DD  "]
[null,"Port",null,null,null,null,null,"Date: "]
[null,"Standard Port",null,null,null,null,null,"Time Zone: ",null,"hrs"]
[null,"Secondary Port"]
[null,"Tidal calculation"]
[null,null,null,null,null,"YYYY-MM-DD   HH:MM"]
[null,"Standard Port HW/LW date, time",null,null,null,null,null,null,null,"Height",null,"metres"]
[null,"Secondary Port differences (note 3)",null,null,null,"Time",null,null,null,"Height",null,"metres"]
[null,null,null,null,null,"YYYY-MM-DD   HH:MM"]
[null,"Secondary Port",null,"Date/Time",null,{"$f":"IF(G16>0,(F15+H16),(F15-H16))","v":"00:00:00"},null,null,null,"Height",{"$f":"SUM(K15:K16)","v":0},"metres"]
[null,null,null,null,null,"YYYY-MM-DD   HH:MM"]
[null,"Standard Port HW/LW date, time",null,null,null,null,null,null,null,"Height",null,"metres"]
[null,"Secondary Port differences (note 3)",null,null,null,"Time",null,null,null,"Height",null,"metres"]
[null,null,null,null,null,"YYYY-MM-DD   HH:MM"]
[null,"Secondary Port",null,"Date/Time",null,{"$f":"IF(G21>0,(F20+H21),(F20-H21))","v":"00:00:00"},null,null,null,"Height",{"$f":"K20+K21","v":0},"metres"]
[]
[null,"Tidal Range (HW Height - LW Height)",null,null,null,null,null,null,null,"Range",{"$f":"ABS(K18-K23)","v":0},"metres"]
[null,"Tidal Duration (HW Time ~ LW Time)",null,null,null,null,null,null,"Duration",{"$f":"ABS(F18-F23)","v":"00:00:00"},null,"Hours"]
[null,null,null,null,null,null,null,null,null,null,"DD HH:MM"]
[null,"(1) Entries may only be made in white cells; all others are protected."]
[null,"(3) For secondary port times, enter ' 1' for ' +' times and ' 0' for ' -' times "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data calculation for Tidal graph"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"time",null,null,"height",null,null,null,null,-2,-1.5,-1,-0.5,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HW",null,{"$f":"'Dep Tide'!$F$18","v":"00:00:00"},null,null,{"$f":"'Dep Tide'!$K$18","v":0},null,null,"time",null,{"$f":"$AQ$75+($AQ$77/10*AY74)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LW",null,{"$f":"'Dep Tide'!$F$23","v":"00:00:00"},null,null,{"$f":"'Dep Tide'!$K$23","v":0},null,null,"factor",null,{"$f":"(1-COS((180-180*AY74/10)*PI()/180))/2","v":0.90450849718747373},0.94550326209418412,0.97552825814757682,0.99384417029756889,1,0.99384417029756889,0.97552825814757682,0.94550326209418389,0.90450849718747373,0.85355339059327373,0.79389262614623646,0.72699524986977337,0.65450849718747373,0.57821723252011548,0.49999999999999994,0.42178276747988452,0.34549150281252627,0.27300475013022663,0.20610737385376343,0.14644660940672621,9.5491502812526274E-2,5.4496737905816051E-2,2.4471741852423234E-2,6.1558297024311148E-3,0,6.1558297024311148E-3,2.4471741852423234E-2,5.4496737905816051E-2,9.5491502812526274E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"range",null,{"$f":"'Dep Tide'!J26","v":"00:00:00"},null,null,{"$f":"AT75-AT76","v":0},null,null,"height",null,{"$f":"($AT$77*AY76)+$AT$76","v":0},{"$f":"($AT$77*AZ76)+$AT$76","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"UKC Restricted at Berth","index":8,"n_rows":103,"n_cols":81,"rows_kept":103,"cut":false,"hidden":false,"merged":[[23,9,23,11],[3,14,3,15],[19,2,19,4],[19,9,19,11],[1,4,2,12],[3,4,4,12],[5,4,6,12],[13,8,13,13],[6,14,6,15],[5,14,5,15],[24,9,24,11],[65,2,65,6],[65,10,65,14],[95,44,95,46],[96,44,96,46]]}
[]
[null,null,null,null,"HEALTH, SAFETY, ENVIRONMENT AND QUALITY MANAGEMENT SYSTEM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Form:","1.3.1"]
[null,null,null,null,"UKC - RESTRICTED BERTH",null,null,null,null,null,null,null,null,"Date:",{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev No.",{"$f":"Common!F4","v":"10.1"}]
[null,null,null,null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E6","v":"File No."},{"$f":"Common!F6","v":"1.3"}]
[]
[]
[null,null,null,null,null,null,"Draft",null,null,null,null,null,null,null,"Depth reductions"]
[null,null,null,null,null,"Vessel's deepest draft:",{"$f":"IF('Departure Port Info'!C22<'Departure Port Info'!C23,'Departure Port Info'!C23,'Departure Port Info'!C22)","v":0},"m",null,null,null,null,null,"Seasonal change",null,"m"]
[null,null,null,null,null,"Changes since departure",null,"m",null,null,null,null,null,"Wave Response Allownace",null,"m"]
[null,null,null,null,null,"Change due to water density",null,"m",null,null,null,null,null,"Allowance for Bottom Variations",null,"m"]
[null,null,null,null,null,"Draft increase due to List",{"$f":"'Departure Port Info'!E26","v":0},"m","Accuracy of Hydrographic Data\n(CATZOG Correction)",null,null,null,null,null,null,"m"]
[]
[null,null,null,null,null,"Ships static draft",{"$f":"SUM(G11:G14)","v":0},"m",null,null,null,null,null,"Depth reductions",{"$f":"SUM(O11:O14)","v":0},"m"]
[]
[]
[null,null,"Critical location 1",null,null,null,null,null,null,"Passing time",null,null,null,null,"Charted depth"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m"]
[null,null,null,null,null,null,null,null,null,"YYYY-MM-DD                      HH:MM"]
[null,null,null,null,null,"Ships static draft",{"$f":"$G$16","v":0},"m",null,{"$f":"IF(AND($J$24<$J$20,$J$20<$J$25),\" \",\"'Passing time' does not match Tide data! \")","v":"'Passing time' does not match Tide data! "}]
[null,null,null,null,null,"Movements in sea and swell",null,"m",null,"Tide          YYYY-MM-DD   HH:MM"]
[null,null,null,null,null,null,null,null,"Tide 1",{"$f":"'Dep Tide'!F18","v":"00:00:00"},null,null,{"$f":"'Dep Tide'!K18","v":0},"m"]
[null,null,null,"Speed",null,null,null,null,"Tide 2",{"$f":"'Dep Tide'!F23","v":"00:00:00"},null,null,{"$f":"'Dep Tide'!K23","v":0},"m"]
[null,null,null,"Channel width",null,null,null,null,null,null,"Passing time",{"$f":"IF(J25>J24,J20-J24,J25-J20)","v":"00:00:00"},"hours"]
[null,null,null,null,null,null,null,null,null,null,"Tidal Duration",{"$f":"J25-J24","v":"00:00:00"},"hours"]
[null,null,null,"Squat -open ",{"$f":"BE82","v":0},null,null,null,null,null,"Factor (see note 2)",{"$f":"IF(L27=0,0,IF(M24<M25,1-(1-COS((180-180*L26/L27)*PI()/180))/2,(1-COS((180-180*L26/L27)*PI()/180))/2))","v":0}]
[null,null,null,"Squat confined ",{"$f":"BG82","v":0},null,null,null,null,null,"Tidal Range",{"$f":"ABS(M24-M25)","v":0},"meters"]
[null,null,null,"D/d ",{"$f":"AY82","v":0},null,null,null,null,null,null,null,null,"Height of tide",{"$f":"IF(M24<M25,(L28*L29)+M24,(L28*L29)+M25)","v":0}]
[]
[null,null,null,"Squat in use",{"$f":"IF(E30>1.4,\"Open\",\"conf\")","v":"conf"},"Squat",{"$f":"'UKC Restricted at Berth'!BI82","v":0},"m",null,null,null,null,null,"depth reductions",{"$f":"$O$16","v":0},"m"]
[]
[null,null,null,null,null,"Ships dynamic draft",{"$f":"G22+G23+G32","v":0},"m",null,null,null,null,null,"Available depth",{"$f":"O20+O30+O32","v":0},"m"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"O34","v":0},"m"]
[null,null,null,null,null,null,null,null,null,{"$f":"G34","v":0},"m"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L39<10,\"Risk assessment required!\",\" \")","v":"Risk assessment required!"}]
[null,null,null,null,null,null,null,null,"UKC under keel clearance ",{"$f":"J36-J37","v":0},"m",{"$f":"IF($G$16=0,0,J39/$G$16*100)","v":0},"% of deepest draught"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2nd Officer",null,null,null,null,null,null,null,"Master"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data for calculating Squat graph"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Block",null,{"$f":"cb","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'UKC Restricted at Berth'!C20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S=As/Ac",{"$f":"IF($O$34=0,0,IF($E$26=0,0,$G$11*Common!C33/$O$34/$E$26))","v":0},null,"S2=S/(1-S)",{"$f":"AS82/(1-AS82)","v":0},null,"d/D",{"$f":"IF($G16=0,0,$O$34/$G$16)","v":0},null,"Shallow/Open?",{"$f":"IF(AY82>1.4,\"Open\",\"Shallow\")","v":"Shallow"},null,"Squat OW",{"$f":"($AS$77/30)*$AV$82^0.6667*$E$25^2.08","v":0},"Squat CW",{"$f":"((6*$AS$82)+0.4)*$AS$77*$E$25^2/100","v":0},"In use",{"$f":"IF($AY$82>1.4,$BE$82,$BG$82)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"speed",null,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,12.5,13,13.5,14,14.5,15,15.5,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open water formula",null,{"$f":"($AS$77/30)*$AV$82^0.6667*AS$84^2.08","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Confined water formula",null,{"$f":"((6*$AS$82)+0.4)*$AS$77*AS$84*AS$84/100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Squat data in use",null,{"$f":"IF($AY$82>1.4,AS85,AS86)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"clearance at zero speed",null,{"$f":"IF($O$34-$G$22-$G$23<10,$O$34-$G$22-$G$23,10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data calculation for Tidal graph"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"time",null,null,"height",null,null,null,null,-2,-1.5,-1,-0.5,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HW",null,{"$f":"J24","v":"00:00:00"},null,null,{"$f":"M24","v":0},null,null,"time",null,{"$f":"$AS$96+($AS$98/10*BA95)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LW",null,{"$f":"J25","v":"00:00:00"},null,null,{"$f":"M25","v":0},null,null,"factor",null,{"$f":"(1-COS((180-180*BA95/10)*PI()/180))/2","v":0.90450849718747373},{"$f":"(1-COS((180-180*BB95/10)*PI()/180))/2","v":0.94550326209418412},{"$f":"(1-COS((180-180*BC95/10)*PI()/180))/2","v":0.97552825814757682},{"$f":"(1-COS((180-180*BD95/10)*PI()/180))/2","v":0.99384417029756889},{"$f":"(1-COS((180-180*BE95/10)*PI()/180))/2","v":1},0.99384417029756889,0.97552825814757682,0.94550326209418389,0.90450849718747373,0.85355339059327373,0.79389262614623646,0.72699524986977337,0.65450849718747373,0.57821723252011548,0.49999999999999994,0.42178276747988452,0.34549150281252627,0.27300475013022663,0.20610737385376343,0.14644660940672621,9.5491502812526274E-2,5.4496737905816051E-2,2.4471741852423234E-2,6.1558297024311148E-3,0,6.1558297024311148E-3,2.4471741852423234E-2,5.4496737905816051E-2,9.5491502812526274E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"range",null,{"$f":"AS97-AS96","v":"00:00:00"},null,null,{"$f":"AV96-AV97","v":0},null,null,"height",null,{"$f":"($AV$98*BA97)+$AV$97","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overhead clearance",null,null,null,"graph limit",null,10,null,"UKC",null,{"$f":"IF($O$20+$O$32-$G$34+BA$98<$AW$100,$O$20+$O$32-$G$34+BA$98,$AW$100)","v":0},{"$f":"IF($O$20+$O$32-$G$34+BB98<$AW$100,$O$20+$O$32-$G$34+BB98,$AW$100)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,{"$f":"IF($O$20+$O$32-$G$34+BA98-(0.1*$G$16)<$AW$100,$O$20+$O$32-$G$34+BA98-(0.1*$G$16),$AW$100)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$20+$O$32-$G$34+BA$98","v":0}]

{"sheet":"Dep UKC Restricted 1","index":9,"n_rows":102,"n_cols":81,"rows_kept":102,"cut":false,"hidden":false,"merged":[[22,9,22,11],[3,14,3,15],[1,4,1,12],[3,4,3,12],[5,4,5,12],[18,2,18,4],[18,9,18,11],[2,14,2,15],[4,14,4,15],[5,14,5,15],[12,8,12,13],[23,9,23,11],[64,2,64,6],[64,10,64,14],[94,44,94,46],[95,44,95,46]]}
[]
[null,null,null,null,"HEALTH, SAFETY,  ENVIRONMENT AND QUALITY MANAGEMENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,null,null,"UKC - Under Keel Clearance - Restricted",null,null,null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,null,null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[]
[]
[null,null,null,null,null,null,"Draft",null,null,null,null,null,null,null,"Depth reductions"]
[null,null,null,null,null,"Vessel's deepest draft:",{"$f":"IF('Departure Port Info'!C22<'Departure Port Info'!C23,'Departure Port Info'!C23,'Departure Port Info'!C22)","v":0},"m",null,null,null,null,null,"Seasonal change",null,"m"]
[null,null,null,null,null,"Changes since departure",null,"m",null,null,null,null,null,"Wave Response Allowance",null,"m"]
[null,null,null,null,null,"Change due to water density",null,"m",null,null,null,null,null,"Allowance for Bottom Variations",null,"m"]
[null,null,null,null,null,"Draft increase due to List",{"$f":"'Departure Port Info'!E26","v":0},"m","Accuracy of Hydrographic Data\n(CATZOG Correction)",null,null,null,null,null,null,"m"]
[]
[null,null,null,null,null,"Ships static draft",{"$f":"SUM(G10:G13)","v":0},"m",null,null,null,null,null,"Depth reductions",{"$f":"SUM(O10:O13)","v":0},"m"]
[]
[]
[null,null,"Critical location 1",null,null,null,null,null,null,"Passing time",null,null,null,null,"Charted depth"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m"]
[null,null,null,null,null,null,null,null,null,"YYYY-MM-DD                      HH:MM"]
[null,null,null,null,null,"Ships static draft",{"$f":"$G$15","v":0},"m",null,{"$f":"IF(AND($J$23<$J$19,$J$19<$J$24),\" \",\"'Passing time' does not match Tide data! \")","v":"'Passing time' does not match Tide data! "}]
[null,null,null,null,null,"Movements in sea and swell",null,"m",null,"Tide          YYYY-MM-DD   HH:MM"]
[null,null,null,null,null,null,null,null,"Tide 1",{"$f":"'Dep Tide'!F18","v":"00:00:00"},null,null,{"$f":"'Dep Tide'!K18","v":0},"m"]
[null,null,null,"Speed",null,"knots",null,null,"Tide 2",{"$f":"'Dep Tide'!F23","v":"00:00:00"},null,null,{"$f":"'Dep Tide'!K23","v":0},"m"]
[null,null,null,"Channel width",null,"m",null,null,null,null,"Passing time",{"$f":"IF(J24>J23,J19-J23,J24-J19)","v":"00:00:00"},"hours"]
[null,null,null,null,null,null,null,null,null,null,"Tidal Duration",{"$f":"J24-J23","v":"00:00:00"},"hours"]
[null,null,null,"Squat -open ",{"$f":"BE81","v":0},null,null,null,null,null,"Factor (see note 2)",{"$f":"IF(L26=0,0,IF(M23<M24,1-(1-COS((180-180*L25/L26)*PI()/180))/2,(1-COS((180-180*L25/L26)*PI()/180))/2))","v":0}]
[null,null,null,"Squat confined ",{"$f":"BG81","v":0},null,null,null,null,null,"Tidal Range",{"$f":"ABS(M23-M24)","v":0},"meters"]
[null,null,null,"D/d ",{"$f":"AY81","v":0},null,null,null,null,null,null,null,null,"Height of tide",{"$f":"IF(M23<M24,(L27*L28)+M23,(L27*L28)+M24)","v":0}]
[]
[null,null,null,"Squat in use",{"$f":"IF(E29>1.4,\"Open\",\"conf\")","v":"conf"},"Squat",{"$f":"'Dep UKC Restricted 1'!BI81","v":0},"m",null,null,null,null,null,"depth reductions",{"$f":"$O$15","v":0},"m"]
[]
[null,null,null,null,null,"Ships dynamic draft",{"$f":"G21+G22+G31","v":0},"m",null,null,null,null,null,"Available depth",{"$f":"O19+O29+O31","v":0},"m"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"O33","v":0},"m"]
[null,null,null,null,null,null,null,null,null,{"$f":"G33","v":0},"m"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L38<10,\"Risk assessment required!\",\" \")","v":"Risk assessment required!"}]
[null,null,null,null,null,null,null,null,"UKC under keel clearance ",{"$f":"J35-J36","v":0},"m",{"$f":"IF($G$33=0,0,J38/$G$33*100)","v":0},"% of deepest draught"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2nd Officer",null,null,null,null,null,null,null,"Master"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data for calculating Squat graph"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Block",null,{"$f":"cb","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Dep UKC Restricted 1'!C19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S=As/Ac",{"$f":"IF($O$33=0,0,IF($E$25=0,0,G10*Common!C33/$O$33/$E$25))","v":0},null,"S2=S/(1-S)",{"$f":"AS81/(1-AS81)","v":0},null,"d/D",{"$f":"IF($G$15=0,0,$O$33/$G$15)","v":0},null,"Shallow/Open?",{"$f":"IF(AY81>1.4,\"Open\",\"Shallow\")","v":"Shallow"},null,"Squat OW",{"$f":"($AS$76/30)*$AV$81^0.6667*$E$24^2.08","v":0},"Squat CW",{"$f":"((6*$AS$81)+0.4)*$AS$76*$E$24^2/100","v":0},"In use",{"$f":"IF($AY$81>1.4,$BE$81,$BG$81)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"speed",null,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,12.5,13,13.5,14,14.5,15,15.5,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open water formula",null,{"$f":"($AS$76/30)*$AV$81^0.6667*AS$83^2.08","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Confined water formula",null,{"$f":"((6*$AS$81)+0.4)*$AS$76*AS$83*AS$83/100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Squat data in use",null,{"$f":"IF($AY$81>1.4,AS84,AS85)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"clearance at zero speed",null,{"$f":"IF($O$33-$G$21-$G$22<10,$O$33-$G$21-$G$22,10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data calculation for Tidal graph"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"time",null,null,"height",null,null,null,null,-2,-1.5,-1,-0.5,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HW",null,{"$f":"J23","v":"00:00:00"},null,null,{"$f":"M23","v":0},null,null,"time",null,{"$f":"$AS$95+($AS$97/10*BA94)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LW",null,{"$f":"J24","v":"00:00:00"},null,null,{"$f":"M24","v":0},null,null,"factor",null,{"$f":"(1-COS((180-180*BA94/10)*PI()/180))/2","v":0.90450849718747373},{"$f":"(1-COS((180-180*BB94/10)*PI()/180))/2","v":0.94550326209418412},{"$f":"(1-COS((180-180*BC94/10)*PI()/180))/2","v":0.97552825814757682},{"$f":"(1-COS((180-180*BD94/10)*PI()/180))/2","v":0.99384417029756889},{"$f":"(1-COS((180-180*BE94/10)*PI()/180))/2","v":1},0.99384417029756889,0.97552825814757682,0.94550326209418389,0.90450849718747373,0.85355339059327373,0.79389262614623646,0.72699524986977337,0.65450849718747373,0.57821723252011548,0.49999999999999994,0.42178276747988452,0.34549150281252627,0.27300475013022663,0.20610737385376343,0.14644660940672621,9.5491502812526274E-2,5.4496737905816051E-2,2.4471741852423234E-2,6.1558297024311148E-3,0,6.1558297024311148E-3,2.4471741852423234E-2,5.4496737905816051E-2,9.5491502812526274E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"range",null,{"$f":"AS96-AS95","v":"00:00:00"},null,null,{"$f":"AV95-AV96","v":0},null,null,"height",null,{"$f":"($AV$97*BA96)+$AV$96","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overhead clearance",null,null,null,"graph limit",null,10,null,"UKC",null,{"$f":"IF($O$19+$O$31-$G$33+BA$97<$AW$99,$O$19+$O$31-$G$33+BA$97,$AW$99)","v":0},{"$f":"IF($O$19+$O$31-$G$33+BB97<$AW$99,$O$19+$O$31-$G$33+BB97,$AW$99)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,{"$f":"IF($O$19+$O$31-$G$33+BA97-(0.1*$G$15)<$AW$99,$O$19+$O$31-$G$33+BA97-(0.1*$G$15),$AW$99)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$19+$O$31-$G$33+BA$97","v":0}]

{"sheet":"Dep Air Draft","index":10,"n_rows":77,"n_cols":82,"rows_kept":77,"cut":false,"hidden":false,"merged":[[72,45,72,47],[1,4,1,12],[3,4,3,12],[5,4,5,12],[10,2,10,4],[10,7,10,9],[11,2,11,4],[3,14,3,15],[19,9,19,11],[20,9,20,11],[53,2,53,6],[53,10,53,14],[71,45,71,47],[2,14,2,15],[4,14,4,15],[5,14,5,15]]}
[]
[null,null,null,null,"HEALTH, SAFETY, ENVIRONMENT AND QUALITY MANAGEMENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,null,null,"Overhead Clearance",null,null,null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,null,null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[]
[]
[]
[null,null,"Overhead restriction",null,null,null,null,"Passing time",null,null,null,null,null,null,"Overhead restriction"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Free Height ",null,"m"]
[null,null,null,null,null,null,null,"YYYY-MM-DD                      HH:MM",null,null,null,null,null,null,null,"m"]
[null,null,null,null,null,null,null,{"$f":"IF(AND($J$20<$H$11,$H$11<$J$21),\" \",\"'Passing time' does not match Tide data! \")","v":"'Passing time' does not match Tide data! "},null,null,null,null,null,"Safety margin",null,"m"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference height for overhead objects",{"$f":"IF(M20<M21,M21,M20)","v":0},"m"]
[null,null,null,null,null,"Ship's highest point above keel",{"$f":"Common!C36","v":0},"m"]
[]
[null,null,null,null,null,"Ships draft aft",{"$f":"'Departure Port Info'!C23","v":0},"m"]
[null,null,null,null,null,null,null,null,null,"Tide          YYYY-MM-DD   HH:MM"]
[null,null,null,null,null,null,null,null,"Tide 1",{"$f":"'Dep Tide'!F18","v":"00:00:00"},null,null,{"$f":"'Dep Tide'!K18","v":0},"height"]
[null,null,null,null,null,null,null,null,"Tide 2",{"$f":"'Dep Tide'!F23","v":"00:00:00"},null,null,{"$f":"'Dep Tide'!K23","v":0},"height"]
[null,null,null,null,null,null,null,null,null,null,"Passing time",{"$f":"IF(J21>J20,H11-J20,J21-H11)","v":"00:00:00"},"hours"]
[null,null,null,null,null,null,null,null,null,null,"Tidal Duration",{"$f":"J21-J20","v":"00:00:00"},"hours","m"]
[null,null,null,null,null,null,null,null,null,null,"Factor (see note 2)",{"$f":"IF(L23=0,0,IF(M20<M21,1-(1-COS((180-180*L22/L23)*PI()/180))/2,(1-COS((180-180*L22/L23)*PI()/180))/2))","v":0},null,"m"]
[null,null,null,null,null,null,null,null,null,null,"Tidal Range",{"$f":"ABS(M20-M21)","v":0},"meters"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Height of tide",{"$f":"IF(M20<M21,(L24*L25)+M20,(L24*L25)+M21)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"height below reference",{"$f":"O15-M27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"height below reference",{"$f":"O15-M27","v":0},"m"]
[]
[]
[]
[null,null,null,null,null,"Ships air draft",{"$f":"G16-G18","v":0},"m",null,null,null,null,null,"Safe overhead clearance",{"$f":"O11-O13+O29","v":0},"m"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"O33","v":0},"m"]
[null,null,null,null,null,null,null,null,null,{"$f":"G33","v":0},"m"]
[]
[null,null,null,null,null,null,null,null,"Ship's safe overhead clearance ",{"$f":"J35-J36","v":0},"m"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2nd Officer",null,null,null,null,null,null,null,"Master"]
[]
[null,"(1) Entries may only be made in white cells; all others are protected."]
[null,"(2) The factor is automatically calculated, and this value may be used for ports outside N.W Europe."]
[null,"    In N.W. Europe, insert the the factor found in Admirality tide tables, graph for the appropriate standard port."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data calculation for Tidal graph"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"time",null,null,"height",null,null,null,null,-2,-1.5,-1,-0.5,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HW",null,{"$f":"J20","v":"00:00:00"},null,null,{"$f":"M20","v":0},null,null,"time",null,{"$f":"$AT$72+($AT$74/10*BB71)","v":"00:00:00"},{"$f":"$AT$72+($AT$74/10*BC71)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LW",null,{"$f":"J21","v":"00:00:00"},null,null,{"$f":"M21","v":0},null,null,"factor",null,{"$f":"(1-COS((180-180*BB71/10)*PI()/180))/2","v":0.90450849718747373},0.94550326209418412,0.97552825814757682,0.99384417029756889,1,0.99384417029756889,0.97552825814757682,0.94550326209418389,0.90450849718747373,0.85355339059327373,0.79389262614623646,0.72699524986977337,0.65450849718747373,0.57821723252011548,0.49999999999999994,0.42178276747988452,0.34549150281252627,0.27300475013022663,0.20610737385376343,0.14644660940672621,9.5491502812526274E-2,5.4496737905816051E-2,2.4471741852423234E-2,6.1558297024311148E-3,0,6.1558297024311148E-3,2.4471741852423234E-2,5.4496737905816051E-2,9.5491502812526274E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"range",null,{"$f":"AT73-AT72","v":"00:00:00"},null,null,{"$f":"AW72-AW73","v":0},null,null,"height",null,{"$f":"($AW$74*BB73)+$AW$73","v":0},{"$f":"($AW$74*BC73)+$AW$73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overhead clearance",null,null,null,"graph limit",null,20,null,null,null,{"$f":"IF($O$11-$O$13+$O$15-$G$33-BB74<$AX$76,$O$11-$O$13+$O$15-$G$33-BB74,$AX$76)","v":0},{"$f":"IF($O$11-$O$13+$O$15-$G$33-BC74<$AX$76,$O$11-$O$13+$O$15-$G$33-BC74,$AX$76)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($O$11+$O$15-$G$33-BB$74<$AX$76,$O$11+$O$15-$G$33-BB$74,$AX$76)","v":0},{"$f":"IF($O$11+$O$15-$G$33-BC$74<$AX$76,$O$11+$O$15-$G$33-BC$74,$AX$76)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Sea Passage","index":11,"n_rows":32,"n_cols":82,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,5,31,7],[11,0,13,0],[11,1,13,1],[11,2,12,4],[11,5,12,7],[9,12,9,14],[8,1,8,2],[1,1,5,17],[1,0,5,0],[11,19,13,19],[11,9,13,9],[11,12,12,15],[10,7,10,12],[7,1,7,2],[8,7,8,9],[9,1,9,2],[9,6,9,9]]}
[]
[null,"HEALTH, SAFETY,  ENVIRONMENT AND QUALITY MANAGEMENT SYSTEM\n\nSEA PASSAGE\n\nREPORTING FORMS MANUAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[null,"All dates & times are GMT",null,null,null,null,null,null,null,null,null,{"$f":"IF(Common!C10=\"\",\"\",Common!C10)","v":""}]
[null,"PILOTS",null,"SPD"," ","Voy :",{"$f":"IF(Common!C11=\"\",\"\",Common!C11)","v":""},{"$f":"IF(Common!C13=\"\",\"\",Common!C13)","v":""},null,null,"Time",null,null,null,null,null,null,null,{"$f":"SPSum1","v":0}]
[null,null,null,null," ","From :",{"$f":"'Checklist A'!$H$12","v":""},null,null,null,{"$f":"IF(Common!C17=\"\",\"\",Common!C17)","v":""},"To :",{"$f":"'Checklist A'!$H$13","v":""},null,null,{"$f":"IF(Common!C21=\"\",\"\",Common!C21)","v":""},null,null,"Sea Passage"]
[null,null,null," "," "," "]
["WP No.","GEOGRAPHICAL AREA WAYPOINT","LATITUDE",null,null,"LONGITUDE",null,null,null,"DIST. TO NEXT WP",null,null,"Fix / Ver Freq / Method",null,null,null,null,null,"Remarks: NAV Aids, Restrictions, Weather,","Watch Level"]
[null,null,null,null,null,null,null,null,"CO",null,"DTG","RL/GC",null,null,null,null,"Max","T&P","Cautions, Traffic Density, UKC, Tides, Abort point etc",null,null,"latrad","longrad","dlon_W","dlon_E","dphi","q1","q","dlon_min","tc_rad","tc","dist_rad","dist"]
[null,null,"DEG","MIN","N/S","DEG","MIN","E/W",null,null,null,null,"Freq","Main","Alt 1","Alt 2","Spd","Notices","T&P notice number effecting each leg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Course","Distance"]
["WP 1",null,null,null,null,null,null,null,{"$f":"IF(C16=\"\",\"\",IF(Y15<X15,360-AE15,AE15))","v":""},{"$f":"IF(C16=\"\",0,+AG15)","v":0},{"$f":"+J32","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E15=\"N\",RADIANS(C15+(D15/60)),-RADIANS(C15+(D15/60)))","v":0},{"$f":"IF(H15=\"E\",+RADIANS(F15+(G15/60)),-RADIANS(F15+(G15/60)))","v":0},{"$f":"MOD(W16-W15,2*PI())","v":0},{"$f":"MOD(W15-W16,2*PI())","v":0},{"$f":"LN(TAN(V16/2+PI()/4)/TAN(V15/2+PI()/4))","v":0},{"$f":"COS(V15)","v":1},{"$f":"IF(V16=V15,AA15,(V16-V15)/Z15)","v":1},{"$f":"MIN(X15,Y15)","v":0},{"$f":"MOD(ATAN2(Z15,AC15),2*PI())","v":{"$error":"#DIV/0!"}},{"$f":"DEGREES(AD15)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(AB15^2*AC15^2+(V16-V15)^2)","v":0},{"$f":"DEGREES(AF15)*60","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I15","v":""},0]
["WP 2",null,null,null,null,null,null,null,"",0,{"$f":"+K15-J15","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E16=\"N\",RADIANS(C16+(D16/60)),-RADIANS(C16+(D16/60)))","v":0},{"$f":"IF(H16=\"E\",+RADIANS(F16+(G16/60)),-RADIANS(F16+(G16/60)))","v":0},{"$f":"MOD(W17-W16,2*PI())","v":0},{"$f":"MOD(W16-W17,2*PI())","v":0},{"$f":"LN(TAN(V17/2+PI()/4)/TAN(V16/2+PI()/4))","v":0},{"$f":"COS(V16)","v":1},{"$f":"IF(V17=V16,AA16,(V17-V16)/Z16)","v":1},{"$f":"MIN(X16,Y16)","v":0},{"$f":"MOD(ATAN2(Z16,AC16),2*PI())","v":{"$error":"#DIV/0!"}},{"$f":"DEGREES(AD16)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(AB16^2*AC16^2+(V17-V16)^2)","v":0},{"$f":"DEGREES(AF16)*60","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["WP 3",null,null,null,null,null,null,null,"",0,{"$f":"+K16-J16","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E17=\"N\",RADIANS(C17+(D17/60)),-RADIANS(C17+(D17/60)))","v":0},{"$f":"IF(H17=\"E\",+RADIANS(F17+(G17/60)),-RADIANS(F17+(G17/60)))","v":0},0,{"$f":"MOD(W17-W18,2*PI())","v":0},{"$f":"LN(TAN(V18/2+PI()/4)/TAN(V17/2+PI()/4))","v":0},{"$f":"COS(V17)","v":1},{"$f":"IF(V18=V17,AA17,(V18-V17)/Z17)","v":1},{"$f":"MIN(X17,Y17)","v":0},{"$f":"MOD(ATAN2(Z17,AC17),2*PI())","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"SQRT(AB17^2*AC17^2+(V18-V17)^2)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["WP 4",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["WP 5",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["WP 6",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["WP 7",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["WP 8",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["WP 9",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["WP 10",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["WP 11",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["WP 12",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["WP 13",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["WP 14",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["WP 15",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["WP 16",null,null,null,null,null,null,null,{"$f":"IF(C31=\"\",\"\",IF(Y30<X30,360-AE30,AE30))","v":""},{"$f":"IF(C31=\"\",0,+AG30)","v":0},{"$f":"+K29-J29","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E30=\"N\",RADIANS(C30+(D30/60)),-RADIANS(C30+(D30/60)))","v":0},{"$f":"IF(H30=\"E\",+RADIANS(F30+(G30/60)),-RADIANS(F30+(G30/60)))","v":0},{"$f":"MOD(W31-W30,2*PI())","v":0},{"$f":"MOD(W30-W31,2*PI())","v":0},{"$f":"LN(TAN(V31/2+PI()/4)/TAN(V30/2+PI()/4))","v":0},{"$f":"COS(V30)","v":1},{"$f":"IF(V31=V30,AA30,(V31-V30)/Z30)","v":1},{"$f":"MIN(X30,Y30)","v":0},{"$f":"MOD(ATAN2(Z30,AC30),2*PI())","v":{"$error":"#DIV/0!"}},{"$f":"DEGREES(AD30)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(AB30^2*AC30^2+(V31-V30)^2)","v":0},{"$f":"DEGREES(AF30)*60","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I30","v":""},{"$f":"J30","v":0}]
[]
[" ",null," "," "," ","TOTAL DISTANCE:",null,null,null,{"$f":"SUM(J15:J31)","v":0},null," ",null,null,null,null,null,null,null,null,null,null," "," "," "," "," "," ",null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," ",null," "," "]

{"sheet":"Sea Passage UKC","index":12,"n_rows":80,"n_cols":77,"rows_kept":80,"cut":false,"hidden":false,"merged":[[3,14,3,15],[1,14,1,15],[2,14,2,15],[4,14,4,15],[5,14,5,15],[1,4,1,12],[2,4,2,12],[3,4,3,12],[5,1,5,3],[5,4,5,12],[12,8,12,13],[22,9,22,11],[23,9,23,11],[53,2,53,6],[53,10,53,14],[18,2,18,4],[18,9,18,11]]}
[]
[null,null,null,null,"HEALTH, SAFETY, ENVIRONMENT AND QUALITY MANAGEMENT",null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,null,null,"UKC - Under Keel Clearance",null,null,null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,"for Pilot To Pilot Route",null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[null,null,null,null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,null,null,null,null,null,{"$f":"Common!E6","v":"File No."},{"$f":"Common!F6","v":"1.3"}]
[]
[]
[null,null,null,"Heel/List",null,null,"Draft",null,null,null,null,null,null,null,"Depth reductions"]
[null,null,null,null,null,"Vessel's deepest draft:",{"$f":"IF('Departure Port Info'!C22<'Departure Port Info'!C23,'Departure Port Info'!C23,'Departure Port Info'!C22)","v":0},"m",null,null,null,null,null,"Seasonal change",null,"m"]
[null,null,null,null,null,"Changes since departure",null,"m",null,null,null,null,null,"Wave Response Allownace",null,"m"]
[null,null,null,null,null,"Change due to water density",null,"m",null,null,null,null,null,"Allowance for Bottom Variations",null,"m"]
[null,null,null,null,null,"Draft increase due to List",{"$f":"TAN(RADIANS(E9))*Common!C33/2","v":0},"m","Accuracy of Hydrographic Data\n(CATZOG Correction)",null,null,null,null,null,null,"m"]
[]
[null,null,null,null,null,"Ships static draft",{"$f":"SUM(G10:G13)","v":0},"m",null,null,null,null,null,"Depth reductions",{"$f":"SUM(O10:O13)","v":0},"m"]
[]
[]
[null,null,"Critical location 1",null,null,null,null,null,null,"Passing time",null,null,null,null,"Charted depth"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m"]
[null,null,null,null,null,null,null,null,null,"YYYY-MM-DD                      HH:MM"]
[null,null,null,null,null,"Ships static draft",{"$f":"$G$15","v":0},"m",null,{"$f":"IF(AND($J$23<$J$19,$J$19<$J$24),\" \",\"'Passing time' does not match Tide data! \")","v":"'Passing time' does not match Tide data! "}]
[null,null,null,null,null,"Movements in sea and swell",null,"m",null,"Tide          YYYY-MM-DD   HH:MM"]
[null,null,null,null,null,null,null,null,"Tide 1",{"$f":"'Dep Tide'!F18","v":"00:00:00"},null,null,{"$f":"'Dep Tide'!K18","v":0},"m"]
[null,null,null,"Speed",null,"knots",null,null,"Tide 2",{"$f":"'Dep Tide'!F23","v":"00:00:00"},null,null,{"$f":"'Dep Tide'!K23","v":0},"m"]
[null,null,null,"Channel width",null,"m",null,null,null,null,"Passing time",{"$f":"IF(J24>J23,J19-J23,J24-J19)","v":"00:00:00"},"hours"]
[null,null,null,null,null,null,null,null,null,null,"Tidal Duration",{"$f":"J24-J23","v":"00:00:00"},"hours"]
[null,null,null,"Squat -open ",{"$f":"BE74","v":0},null,null,null,null,null,"Factor (see note 2)",{"$f":"IF(L26=0,0,IF(M23<M24,1-(1-COS((180-180*L25/L26)*PI()/180))/2,(1-COS((180-180*L25/L26)*PI()/180))/2))","v":0}]
[null,null,null,"Squat confined ",{"$f":"BG74","v":0},null,null,null,null,null,"Tidal Range",{"$f":"ABS(M23-M24)","v":0},"meters"]
[null,null,null,"D/d ",{"$f":"AY74","v":0},null,null,null,null,null,null,null,null,"Height of tide",{"$f":"IF(M23<M24,(L27*L28)+M23,(L27*L28)+M24)","v":0}]
[]
[null,null,null,"Squat in use",{"$f":"IF(E29>1.4,\"Open\",\"conf\")","v":"conf"},"Squat",{"$f":"'Sea Passage UKC'!BI74","v":0},"m",null,null,null,null,null,"depth reductions",{"$f":"$O$15","v":0},"m"]
[]
[null,null,null,null,null,"Ships dynamic draft",{"$f":"G21+G22+G31","v":0},"m",null,null,null,null,null,"Available depth",{"$f":"O19+O29+O31","v":0},"m"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"O33","v":0},"m"]
[null,null,null,null,null,null,null,null,null,{"$f":"G33","v":0},"m"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L38<20,\"Risk assessment required!\",\" \")","v":"Risk assessment required!"}]
[null,null,null,null,null,null,null,null,"UKC under keel clearance ",{"$f":"J35-J36","v":0},"m",{"$f":"IF($G$33=0,0,J38/$G$33*100)","v":0},"% of deepest draught"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2nd Officer",null,null,null,null,null,null,null,"Master"]
[]
[null,"(1) Entries may only be made in white cells; all others are protected."]
[null,"(2) The factor is automatically calculated, and this value may be used for ports outside N.W Europe."]
[null,"In N.W. Europe,insert the the factor found in Admirality tide tables, graph for the appropriate standard port."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data for calculating Squat graph"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Block",null,{"$f":"cb","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Sea Passage UKC'!C19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S=As/Ac",{"$f":"IF($O$33=0,0,IF($E$25=0,0,G10*Common!C33/$O$33/$E$25))","v":0},null,"S2=S/(1-S)",{"$f":"AS74/(1-AS74)","v":0},null,"d/D",{"$f":"IF($G$15=0,0,$O$33/$G$15)","v":0},null,"Shallow/Open?",{"$f":"IF(AY74>1.4,\"Open\",\"Shallow\")","v":"Shallow"},null,"Squat OW",{"$f":"($AS$69/30)*$AV$74^0.6667*$E$24^2.08","v":0},"Squat CW",{"$f":"((6*$AS$74)+0.4)*$AS$69*$E$24^2/100","v":0},"In use",{"$f":"IF($AY$74>1.4,$BE$74,$BG$74)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"speed",null,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,12.5,13,13.5,14,14.5,15,15.5,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open water formula",null,{"$f":"($AS$69/30)*$AV$74^0.6667*AS$76^2.08","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Confined water formula",null,{"$f":"((6*$AS$74)+0.4)*$AS$69*AS$76*AS$76/100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Squat data in use",null,{"$f":"IF($AY$74>1.4,AS77,AS78)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"clearance at zero speed",null,{"$f":"IF($O$33-$G$21-$G$22<10,$O$33-$G$21-$G$22,10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Implementation","index":13,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,2,0,9],[2,2,2,9],[4,2,4,9]]}
[null,null,"HEALTH, SAFETY, ENVIRONMENT AND QUALITY MANAGEMENT"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,"Passage Plans - Implementation",null,null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
["CHARTS","Chart Corrected upto ","NO-GO Areas (As per BTM Practical Guide Diag 1)","Margins Of Safety (As per BTM Practical Guide Diag 2)","Chart Change  (Clearly Marked)","Under Keel Clearance  (Is Filled TSM 002 - available if applicable)","Wheel-Over Position (As per BTM Practical Guide Diag 4 WOP)","Parallel Index (As per BTM Practical Guide Diag 5)","Abort Position / Contigency Plan advocated","Position Fixing Method & Interval","T&P Notices","Duty Officer's Initials"]

{"sheet":"Arrival Port Info","index":14,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[35,2,35,6],[17,0,17,1],[18,0,18,1],[20,0,20,1],[21,0,21,1],[30,5,30,6],[31,5,31,6],[33,0,33,1],[32,2,32,6],[33,2,33,6],[34,2,34,6],[23,0,23,1],[22,0,22,1],[19,0,19,6],[20,2,20,3],[21,2,21,3],[39,0,39,6],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[37,0,37,6],[34,0,34,1],[35,0,35,1],[25,0,25,1],[26,0,26,1],[32,0,32,1],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[5,5,5,6],[6,0,6,6],[11,0,11,6],[0,1,0,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[7,2,7,6],[13,2,13,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[12,2,12,6]]}
[null,"HEALTH, SAFETY, ENVIRONMENT AND QUALITY MANAGEMENT"]
[null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,"Passage Plan- Arrival Port Info",null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[]
["PORT OF ARRIVAL INFORMATION"]
["Name of Arrival Berth"]
["VHF Channel(s) - Port Control"]
["VHF Channel(s) - VTS"]
["VHF Channel(s) - Pilots"]
["Tidal Information"]
["Standard Port"]
["Date"]
[null,null,"TIME ",null,"HEIGHT"]
["High Water",null,null,null,null,"Mtrs"]
["Low Water",null,null,null,null,{"$f":"$F$16","v":"Mtrs"}]
["High Water",null,null,null,null,{"$f":"$F$16","v":"Mtrs"}]
["Low Water",null,null,null,null,{"$f":"$F$16","v":"Mtrs"}]
["Estimated Draft on Arrival"]
["Forward",null,null,null,"Mtrs"]
["Aft",null,null,null,"Mtrs"]
["Mean",null,{"$f":"(C21+C22)/2","v":0},null,"Mtrs"]
["Vessel’s Maximum Air-draft",null,{"$f":"Common!C36-C22","v":0},null,"Mtrs"]
["Heel/List",null,null,null,{"$f":"TAN(RADIANS(C25))*Common!C33/2","v":0},"Mtrs"]
["Distance - Pilot to Berth Station",null,{"$f":"PBSum2","v":0}]
["Estimated Time to Berth Station",null,{"$f":"'Checklist A'!N17","v":"00:00:00"},null,"Is there an overhead obstruction:"]
[null,null,"Restricted 1","Berth"]
[null,{"$f":"IF(G27=\"NO\",\"\",\"Overhead Cleance\")","v":"Overhead Cleance"},{"$f":"IF(G27=\"No\",\"\",'Air Draft'!J38)","v":0},"n/a"]
[null,"Minium UKC",{"$f":"'Arr UKC Restricted 1'!J38","v":0},{"$f":"'UKC Restricted at Arr Berth'!J38","v":0}]
[null,"Maximum Squat",{"$f":"'Arr UKC Restricted 1'!G31","v":0},{"$f":"'UKC Restricted at Arr Berth'!G31","v":0},{"$f":"C28","v":"Restricted 1"},{"$f":"D28","v":"Berth"}]
[null,"UKC (Deepest draft + squat)",{"$f":"'Arr UKC Restricted 1'!L38","v":0},{"$f":"'UKC Restricted at Arr Berth'!L38","v":0},{"$f":"IF(C32<10,\"Risk Assessment required!\",\"\")","v":"Risk Assessment required!"},{"$f":"IF(D32<10,\"Risk Assessment required!\",\"\")","v":"Risk Assessment required!"}]
["Is There a Change of Pilots?"]
["If Yes, Where"]
["Number of Tugs"]
["Location Tugs will approach Vessel"]
["Remarks: (General route, channel to use, special precaution, etc)"]
[]
["Prevailing Current / Weather Information "]

{"sheet":"Pilot to Berth","index":15,"n_rows":34,"n_cols":82,"rows_kept":34,"cut":false,"hidden":false,"merged":[[6,2,6,17],[11,19,13,19],[33,5,33,7],[11,0,13,0],[11,1,13,1],[11,2,12,4],[11,5,12,7],[11,9,13,9],[11,12,12,15],[10,7,10,12],[7,1,7,2],[8,7,8,9],[9,1,9,2],[9,6,9,9],[9,12,9,14],[1,2,1,17],[2,2,2,17],[3,2,3,17],[4,2,4,17],[5,2,5,17]]}
[]
[null,null,"HEALTH, SAFETY, ENVIRONMENT AND QUALITY MANAGEMENT SYSTEM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,"WAYPOINT LIST - PILOT TO PILOT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,"REPORTING FORMS MANUAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E6","v":"File No."},{"$f":"Common!F6","v":"1.3"}]
[null,"All dates & times are GMT",null,null,null,null,null,null,null,null,null,{"$f":"IF(Common!C10=\"\",\"\",Common!C10)","v":""}]
[null,"PILOTS",null,"SPD"," ","Voy :",{"$f":"IF(Common!C11=\"\",\"\",Common!C11)","v":""},{"$f":"IF(Common!C13=\"\",\"\",Common!C13)","v":""},null,null,"Time",null,null,null,null,null,null,null,{"$f":"PBSum1","v":0}]
[null,null,null,null," ","From :",{"$f":"'Checklist A'!$H$13","v":""},null,null,null,{"$f":"IF(Common!C17=\"\",\"\",Common!C17)","v":""},"To :",{"$f":"'Checklist A'!$L$13","v":""},null,null,{"$f":"IF(Common!C21=\"\",\"\",Common!C21)","v":""},null,null,"Pilot to Berth"]
[null,null,null," "," "," "]
["WP No.","GEOGRAPHICAL AREA WAYPOINT","LATITUDE",null,null,"LONGITUDE",null,null,null,"DIST. TO NEXT WP",null,null,"Fix / Ver Freq / Method",null,null,null,null,null,"Remarks: NAV Aids, Restrictions, Weather,","Watch Level"]
[null,null,null,null,null,null,null,null,"CO",null,"DTG","RL/GC",null,null,null,null,"Max","T&P","Cautions, Traffic Density, UKC, Tides, Abort point etc",null,null,"latrad","longrad","dlon_W","dlon_E","dphi","q1","q","dlon_min","tc_rad","tc","dist_rad","dist"]
[null,null,"DEG","MIN","N/S","DEG","MIN","E/W",null,null,null,null,"Freq","Main","Alt 1","Alt 2","Spd","Notices","T&P notice number effecting each leg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Course","Distance"]
["PB 1",null,null,null,null,null,null,null,{"$f":"IF(C16=\"\",\"\",IF(Y15<X15,360-AE15,AE15))","v":""},{"$f":"IF(C16=\"\",0,+AG15)","v":0},{"$f":"+J34","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E15=\"N\",RADIANS(C15+(D15/60)),-RADIANS(C15+(D15/60)))","v":0},{"$f":"IF(H15=\"E\",+RADIANS(F15+(G15/60)),-RADIANS(F15+(G15/60)))","v":0},{"$f":"MOD(W16-W15,2*PI())","v":0},{"$f":"MOD(W15-W16,2*PI())","v":0},{"$f":"LN(TAN(V16/2+PI()/4)/TAN(V15/2+PI()/4))","v":0},{"$f":"COS(V15)","v":1},{"$f":"IF(V16=V15,AA15,(V16-V15)/Z15)","v":1},{"$f":"MIN(X15,Y15)","v":0},{"$f":"MOD(ATAN2(Z15,AC15),2*PI())","v":{"$error":"#DIV/0!"}},{"$f":"DEGREES(AD15)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(AB15^2*AC15^2+(V16-V15)^2)","v":0},{"$f":"DEGREES(AF15)*60","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I15","v":""},0]
["PB 2",null,null,null,null,null,null,null,{"$f":"IF(C17=\"\",\"\",IF(Y16<X16,360-AE16,AE16))","v":""},{"$f":"IF(C17=\"\",0,+AG16)","v":0},{"$f":"+K15-J15","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E16=\"N\",RADIANS(C16+(D16/60)),-RADIANS(C16+(D16/60)))","v":0},{"$f":"IF(H16=\"E\",+RADIANS(F16+(G16/60)),-RADIANS(F16+(G16/60)))","v":0},{"$f":"MOD(W17-W16,2*PI())","v":0},{"$f":"MOD(W16-W17,2*PI())","v":0},{"$f":"LN(TAN(V17/2+PI()/4)/TAN(V16/2+PI()/4))","v":0},{"$f":"COS(V16)","v":1},{"$f":"IF(V17=V16,AA16,(V17-V16)/Z16)","v":1},{"$f":"MIN(X16,Y16)","v":0},{"$f":"MOD(ATAN2(Z16,AC16),2*PI())","v":{"$error":"#DIV/0!"}},{"$f":"DEGREES(AD16)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(AB16^2*AC16^2+(V17-V16)^2)","v":0},{"$f":"DEGREES(AF16)*60","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["PB 3",null,null,null,null,null,null,null,{"$f":"IF(C18=\"\",\"\",IF(Y17<X17,360-AE17,AE17))","v":""},{"$f":"IF(C18=\"\",0,+AG17)","v":0},{"$f":"+K16-J16","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E17=\"N\",RADIANS(C17+(D17/60)),-RADIANS(C17+(D17/60)))","v":0},{"$f":"IF(H17=\"E\",+RADIANS(F17+(G17/60)),-RADIANS(F17+(G17/60)))","v":0},0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["PB 4",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["PB 5",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["PB 6",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["PB 7",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["PB 8",null,null,null,null,null,null,null,{"$f":"IF(C23=\"\",\"\",IF(Y22<X22,360-AE22,AE22))","v":""},{"$f":"IF(C23=\"\",0,+AG22)","v":0},0,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"MOD(W23-W22,2*PI())","v":0},{"$f":"MOD(W22-W23,2*PI())","v":0},{"$f":"LN(TAN(V23/2+PI()/4)/TAN(V22/2+PI()/4))","v":0},1,{"$f":"IF(V23=V22,AA22,(V23-V22)/Z22)","v":1},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SQRT(AB22^2*AC22^2+(V23-V22)^2)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["PB 9",null,null,null,null,null,null,null,"",0,{"$f":"+K22-J22","v":0},null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["PB 10",null,null,null,null,null,null,null,"",0,{"$f":"+K23-J23","v":0},null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["PB 11",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["PB 12",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["PB 13",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["PB 14",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["PB 15",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["PB 16",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["PB 17",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
["PB 18",null,null,null,null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,1,1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0]
[]
[null,null,null,null,null,"TOTAL DISTANCE:",null,null,null,{"$f":"SUM(J15:J33)","v":0}]

{"sheet":"Arrival Tide","index":16,"n_rows":76,"n_cols":79,"rows_kept":76,"cut":false,"hidden":false,"merged":[[1,3,1,9],[74,42,74,44],[13,5,13,7],[16,5,16,7],[18,5,18,7],[21,5,21,7],[24,9,24,10],[73,42,73,44],[10,3,10,6],[3,11,3,12],[3,3,3,9],[5,3,5,9],[8,3,8,6],[8,8,8,10],[9,3,9,6]]}
[]
[null,null,null,"HEALTH, SAFETY, ENVIRONMENT AND QUALITY MANAGEMENT"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,null,"SIMPLIFIED TIDE CALCULATION",null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[]
[null,null,null,null,null,null,null,null,"YYYY-MM-DD  "]
[null,"Port",null,null,null,null,null,"Date: "]
[null,"Standard Port",null,null,null,null,null,"Time Zone: ",null,"hrs"]
[null,"Secondary Port"]
[null,"Tidal calculation"]
[null,null,null,null,null,"YYYY-MM-DD   HH:MM"]
[null,"Standard Port HW/LW date, time",null,null,null,null,null,null,null,"Height",null,"metres"]
[null,"Secondary Port differences (note 3)",null,null,null,"Time",null,null,null,"Height",null,"metres"]
[null,null,null,null,null,"YYYY-MM-DD   HH:MM"]
[null,"Secondary Port",null,"Date/Time",null,{"$f":"IF(G15>0,(F14+H15),(F14-H15))","v":"00:00:00"},null,null,null,"Height",{"$f":"SUM(K14:K15)","v":0},"metres"]
[null,null,null,null,null,"YYYY-MM-DD   HH:MM"]
[null,"Standard Port HW/LW date, time",null,null,null,null,null,null,null,"Height",null,"metres"]
[null,"Secondary Port differences (note 3)",null,null,null,"Time",null,null,null,"Height",null,"metres"]
[null,null,null,null,null,"YYYY-MM-DD   HH:MM"]
[null,"Secondary Port",null,"Date/Time",null,{"$f":"IF(G20>0,(F19+H20),(F19-H20))","v":"00:00:00"},null,null,null,"Height",{"$f":"K19+K20","v":0},"metres"]
[]
[null,"Tidal Range (HW Height - LW Height)",null,null,null,null,null,null,null,"Range",{"$f":"ABS(K17-K22)","v":0},"metres"]
[null,"Tidal Duration (HW Time ~ LW Time)",null,null,null,null,null,null,"Duration",{"$f":"ABS(F17-F22)","v":"00:00:00"},null,"Hours"]
[null,null,null,null,null,null,null,null,null,null,"DD HH:MM"]
[null,"(1) Entries may only be made in white cells; all others are protected."]
[null,"(3) For secondary port times, enter ' 1' for ' +' times and ' 0' for ' -' times "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data calculation for Tidal graph"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"time",null,null,"height",null,null,null,null,-2,-1.5,-1,-0.5,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HW",null,{"$f":"'Arrival Tide'!$F$17","v":"00:00:00"},null,null,{"$f":"'Arrival Tide'!$K$17","v":0},null,null,"time",null,{"$f":"$AQ$74+($AQ$76/10*AY73)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LW",null,{"$f":"'Arrival Tide'!$F$22","v":"00:00:00"},null,null,{"$f":"'Arrival Tide'!$K$22","v":0},null,null,"factor",null,{"$f":"(1-COS((180-180*AY73/10)*PI()/180))/2","v":0.90450849718747373},0.94550326209418412,0.97552825814757682,0.99384417029756889,1,0.99384417029756889,0.97552825814757682,0.94550326209418389,0.90450849718747373,0.85355339059327373,0.79389262614623646,0.72699524986977337,0.65450849718747373,0.57821723252011548,0.49999999999999994,0.42178276747988452,0.34549150281252627,0.27300475013022663,0.20610737385376343,0.14644660940672621,9.5491502812526274E-2,5.4496737905816051E-2,2.4471741852423234E-2,6.1558297024311148E-3,0,6.1558297024311148E-3,2.4471741852423234E-2,5.4496737905816051E-2,9.5491502812526274E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"range",null,{"$f":"'Arrival Tide'!J25","v":"00:00:00"},null,null,{"$f":"AT74-AT75","v":0},null,null,"height",null,{"$f":"($AT$76*AY75)+$AT$75","v":0},{"$f":"($AT$76*AZ75)+$AT$75","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Arr UKC Restricted 1","index":17,"n_rows":102,"n_cols":81,"rows_kept":102,"cut":false,"hidden":false,"merged":[[22,9,22,11],[3,14,3,15],[1,4,1,12],[3,4,3,12],[5,4,5,12],[18,2,18,4],[18,9,18,11],[12,8,12,13],[23,9,23,11],[64,2,64,6],[64,10,64,14],[94,44,94,46],[95,44,95,46]]}
[]
[null,null,null,null,"HEALTH, SAFETY, ENVIRONMENT AND QUALITY MANAGEMENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,null,null,"UKC - Under Keel Clearance - Restricted",null,null,null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,null,null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[]
[]
[null,null,null,null,null,null,"Draft",null,null,null,null,null,null,null,"Depth reductions"]
[null,null,null,null,null,"Vessel's deepest draft:",{"$f":"IF('Arrival Port Info'!C22<'Arrival Port Info'!C23,'Arrival Port Info'!C23,'Arrival Port Info'!C22)","v":0},"m",null,null,null,null,null,"Seasonal change",null,"m"]
[null,null,null,null,null,"Changes since departure",null,"m",null,null,null,null,null,"Wave Response Allownace",null,"m"]
[null,null,null,null,null,"Change due to water density",null,"m",null,null,null,null,null,"Allowance for Bottom Variations",null,"m"]
[null,null,null,null,null,"Draft increase due to List",{"$f":"'Arrival Port Info'!E25","v":0},"m","Accuracy of Hydrographic Data\n(CATZOG Correction)",null,null,null,null,null,null,"m"]
[]
[null,null,null,null,null,"Ships static draft",{"$f":"SUM(G10:G13)","v":0},"m",null,null,null,null,null,"Depth reductions",{"$f":"SUM(O10:O13)","v":0},"m"]
[]
[]
[null,null,"Critical location 1",null,null,null,null,null,null,"Passing time",null,null,null,null,"Charted depth"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m"]
[null,null,null,null,null,null,null,null,null,"YYYY-MM-DD                      HH:MM"]
[null,null,null,null,null,"Ships static draft",{"$f":"$G$15","v":0},"m",null,{"$f":"IF(AND($J$23<$J$19,$J$19<$J$24),\" \",\"'Passing time' does not match Tide data! \")","v":"'Passing time' does not match Tide data! "}]
[null,null,null,null,null,"Movements in sea and swell",null,"m",null,"Tide          YYYY-MM-DD   HH:MM"]
[null,null,null,null,null,null,null,null,"Tide 1",{"$f":"'Arrival Tide'!F17","v":"00:00:00"},null,null,{"$f":"'Arrival Tide'!K17","v":0},"m"]
[null,null,null,"Speed",null,"knots",null,null,"Tide 2",{"$f":"'Arrival Tide'!F22","v":"00:00:00"},null,null,{"$f":"'Arrival Tide'!K22","v":0},"m"]
[null,null,null,"Channel width",null,"m",null,null,null,null,"Passing time",{"$f":"IF(J24>J23,J19-J23,J24-J19)","v":"00:00:00"},"hours"]
[null,null,null,null,null,null,null,null,null,null,"Tidal Duration",{"$f":"J24-J23","v":"00:00:00"},"hours"]
[null,null,null,"Squat -open ",{"$f":"BE81","v":0},null,null,null,null,null,"Factor (see note 2)",{"$f":"IF(L26=0,0,IF(M23<M24,1-(1-COS((180-180*L25/L26)*PI()/180))/2,(1-COS((180-180*L25/L26)*PI()/180))/2))","v":0}]
[null,null,null,"Squat confined ",{"$f":"BG81","v":0},null,null,null,null,null,"Tidal Range",{"$f":"ABS(M23-M24)","v":0},"meters"]
[null,null,null,"D/d ",{"$f":"AY81","v":0},null,null,null,null,null,null,null,null,"Height of tide",{"$f":"IF(M23<M24,(L27*L28)+M23,(L27*L28)+M24)","v":0}]
[]
[null,null,null,"Squat in use",{"$f":"IF(E29>1.4,\"Open\",\"conf\")","v":"conf"},"Squat",{"$f":"'Arr UKC Restricted 1'!BI81","v":0},"m",null,null,null,null,null,"depth reductions",{"$f":"$O$15","v":0},"m"]
[]
[null,null,null,null,null,"Ships dynamic draft",{"$f":"G21+G22+G31","v":0},"m",null,null,null,null,null,"Available depth",{"$f":"O19+O29+O31","v":0},"m"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"O33","v":0},"m"]
[null,null,null,null,null,null,null,null,null,{"$f":"G33","v":0},"m"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L38<10,\"Risk assessment required!\",\" \")","v":"Risk assessment required!"}]
[null,null,null,null,null,null,null,null,"UKC under keel clearance ",{"$f":"J35-J36","v":0},"m",{"$f":"IF($G$33=0,0,J38/$G$33*100)","v":0},"% of deepest draught"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2nd Officer",null,null,null,null,null,null,null,"Master"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data for calculating Squat graph"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Block",null,{"$f":"cb","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Arr UKC Restricted 1'!C19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S=As/Ac",{"$f":"IF($O$33=0,0,IF($E$25=0,0,G10*Common!C33/$O$33/$E$25))","v":0},null,"S2=S/(1-S)",{"$f":"AS81/(1-AS81)","v":0},null,"d/D",{"$f":"IF($G$15=0,0,$O$33/$G$15)","v":0},null,"Shallow/Open?",{"$f":"IF(AY81>1.4,\"Open\",\"Shallow\")","v":"Shallow"},null,"Squat OW",{"$f":"($AS$76/30)*$AV$81^0.6667*$E$24^2.08","v":0},"Squat CW",{"$f":"((6*$AS$81)+0.4)*$AS$76*$E$24^2/100","v":0},"In use",{"$f":"IF($AY$81>1.4,$BE$81,$BG$81)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"speed",null,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,12.5,13,13.5,14,14.5,15,15.5,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open water formula",null,{"$f":"($AS$76/30)*$AV$81^0.6667*AS$83^2.08","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Confined water formula",null,{"$f":"((6*$AS$81)+0.4)*$AS$76*AS$83*AS$83/100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Squat data in use",null,{"$f":"IF($AY$81>1.4,AS84,AS85)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"clearance at zero speed",null,{"$f":"IF($O$33-$G$21-$G$22<10,$O$33-$G$21-$G$22,10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data calculation for Tidal graph"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"time",null,null,"height",null,null,null,null,-2,-1.5,-1,-0.5,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HW",null,{"$f":"J23","v":"00:00:00"},null,null,{"$f":"M23","v":0},null,null,"time",null,{"$f":"$AS$95+($AS$97/10*BA94)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LW",null,{"$f":"J24","v":"00:00:00"},null,null,{"$f":"M24","v":0},null,null,"factor",null,{"$f":"(1-COS((180-180*BA94/10)*PI()/180))/2","v":0.90450849718747373},{"$f":"(1-COS((180-180*BB94/10)*PI()/180))/2","v":0.94550326209418412},{"$f":"(1-COS((180-180*BC94/10)*PI()/180))/2","v":0.97552825814757682},{"$f":"(1-COS((180-180*BD94/10)*PI()/180))/2","v":0.99384417029756889},{"$f":"(1-COS((180-180*BE94/10)*PI()/180))/2","v":1},0.99384417029756889,0.97552825814757682,0.94550326209418389,0.90450849718747373,0.85355339059327373,0.79389262614623646,0.72699524986977337,0.65450849718747373,0.57821723252011548,0.49999999999999994,0.42178276747988452,0.34549150281252627,0.27300475013022663,0.20610737385376343,0.14644660940672621,9.5491502812526274E-2,5.4496737905816051E-2,2.4471741852423234E-2,6.1558297024311148E-3,0,6.1558297024311148E-3,2.4471741852423234E-2,5.4496737905816051E-2,9.5491502812526274E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"range",null,{"$f":"AS96-AS95","v":"00:00:00"},null,null,{"$f":"AV95-AV96","v":0},null,null,"height",null,{"$f":"($AV$97*BA96)+$AV$96","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overhead clearance",null,null,null,"graph limit",null,10,null,"UKC",null,{"$f":"IF($O$19+$O$31-$G$33+BA$97<$AW$99,$O$19+$O$31-$G$33+BA$97,$AW$99)","v":0},{"$f":"IF($O$19+$O$31-$G$33+BB97<$AW$99,$O$19+$O$31-$G$33+BB97,$AW$99)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,{"$f":"IF($O$19+$O$31-$G$33+BA97-(0.1*$G$15)<$AW$99,$O$19+$O$31-$G$33+BA97-(0.1*$G$15),$AW$99)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$19+$O$31-$G$33+BA$97","v":0}]

{"sheet":"UKC Restricted at Arr Berth","index":18,"n_rows":102,"n_cols":81,"rows_kept":102,"cut":false,"hidden":false,"merged":[[22,9,22,11],[3,14,3,15],[1,4,1,12],[3,4,3,12],[5,4,5,12],[18,2,18,4],[18,9,18,11],[12,8,12,13],[2,14,2,15],[23,9,23,11],[64,2,64,6],[64,10,64,14],[94,44,94,46],[95,44,95,46]]}
[]
[null,null,null,null,"SAFETY, HEALTH, ENVIRONMENT AND QUALITY MANAGEMENT",null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,"UKC - Under Keel Clearance - Restricted",null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[null,null,null,null,"SHIP REPORTING  FORMS  MANUAL"]
[]
[]
[null,null,null,null,null,null,"Draft",null,null,null,null,null,null,null,"Depth reductions"]
[null,null,null,null,null,"Vessel's deepest draft:",{"$f":"IF('Departure Port Info'!C22<'Departure Port Info'!C23,'Departure Port Info'!C23,'Departure Port Info'!C22)","v":0},"m",null,null,null,null,null,"Seasonal change",null,"m"]
[null,null,null,null,null,"Changes since departure",null,"m",null,null,null,null,null,"Wave Response Allownace",null,"m"]
[null,null,null,null,null,"Change due to water density",null,"m",null,null,null,null,null,"Allowance for Bottom Variations",null,"m"]
[null,null,null,null,null,"Draft increase due to List",{"$f":"'Departure Port Info'!E26","v":0},"m","Accuracy of Hydrographic Data\n(CATZOG Correction)",null,null,null,null,null,null,"m"]
[]
[null,null,null,null,null,"Ships static draft",{"$f":"SUM(G10:G13)","v":0},"m",null,null,null,null,null,"Depth reductions",{"$f":"SUM(O10:O13)","v":0},"m"]
[]
[]
[null,null,"Critical location 1",null,null,null,null,null,null,"Passing time",null,null,null,null,"Charted depth"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m"]
[null,null,null,null,null,null,null,null,null,"YYYY-MM-DD                      HH:MM"]
[null,null,null,null,null,"Ships static draft",{"$f":"$G$15","v":0},"m",null,{"$f":"IF(AND($J$23<$J$19,$J$19<$J$24),\" \",\"'Passing time' does not match Tide data! \")","v":"'Passing time' does not match Tide data! "}]
[null,null,null,null,null,"Movements in sea and swell",null,"m",null,"Tide          YYYY-MM-DD   HH:MM"]
[null,null,null,null,null,null,null,null,"Tide 1",{"$f":"'Arrival Tide'!F17","v":"00:00:00"},null,null,{"$f":"'Arrival Tide'!K17","v":0},"m"]
[null,null,null,"Speed",null,"knots",null,null,"Tide 2",{"$f":"'Arrival Tide'!F22","v":"00:00:00"},null,null,{"$f":"'Arrival Tide'!K22","v":0},"m"]
[null,null,null,"Channel width",null,"m",null,null,null,null,"Passing time",{"$f":"IF(J24>J23,J19-J23,J24-J19)","v":"00:00:00"},"hours"]
[null,null,null,null,null,null,null,null,null,null,"Tidal Duration",{"$f":"J24-J23","v":"00:00:00"},"hours"]
[null,null,null,"Squat -open ",{"$f":"BE81","v":0},null,null,null,null,null,"Factor (see note 2)",{"$f":"IF(L26=0,0,IF(M23<M24,1-(1-COS((180-180*L25/L26)*PI()/180))/2,(1-COS((180-180*L25/L26)*PI()/180))/2))","v":0}]
[null,null,null,"Squat confined ",{"$f":"BG81","v":0},null,null,null,null,null,"Tidal Range",{"$f":"ABS(M23-M24)","v":0},"meters"]
[null,null,null,"D/d ",{"$f":"AY81","v":0},null,null,null,null,null,null,null,null,"Height of tide",{"$f":"IF(M23<M24,(L27*L28)+M23,(L27*L28)+M24)","v":0}]
[]
[null,null,null,"Squat in use",{"$f":"IF(E29>1.4,\"Open\",\"conf\")","v":"conf"},"Squat",{"$f":"'UKC Restricted at Arr Berth'!BI81","v":0},"m",null,null,null,null,null,"depth reductions",{"$f":"$O$15","v":0},"m"]
[]
[null,null,null,null,null,"Ships dynamic draft",{"$f":"G21+G22+G31","v":0},"m",null,null,null,null,null,"Available depth",{"$f":"O19+O29+O31","v":0},"m"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"O33","v":0},"m"]
[null,null,null,null,null,null,null,null,null,{"$f":"G33","v":0},"m"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L38<10,\"Risk assessment required!\",\" \")","v":"Risk assessment required!"}]
[null,null,null,null,null,null,null,null,"UKC under keel clearance ",{"$f":"J35-J36","v":0},"m",{"$f":"IF($G$33=0,0,J38/$G$33*100)","v":0},"% of deepest draught"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2nd Officer",null,null,null,null,null,null,null,"Master"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data for calculating Squat graph"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Block",null,{"$f":"cb","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'UKC Restricted at Arr Berth'!C19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S=As/Ac",{"$f":"IF($O$33=0,0,IF($E$25=0,0,G10*Common!C33/$O$33/$E$25))","v":0},null,"S2=S/(1-S)",{"$f":"AS81/(1-AS81)","v":0},null,"d/D",{"$f":"IF($G$15=0,0,$O$33/$G$15)","v":0},null,"Shallow/Open?",{"$f":"IF(AY81>1.4,\"Open\",\"Shallow\")","v":"Shallow"},null,"Squat OW",{"$f":"($AS$76/30)*$AV$81^0.6667*$E$24^2.08","v":0},"Squat CW",{"$f":"((6*$AS$81)+0.4)*$AS$76*$E$24^2/100","v":0},"In use",{"$f":"IF($AY$81>1.4,$BE$81,$BG$81)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"speed",null,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,12.5,13,13.5,14,14.5,15,15.5,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open water formula",null,{"$f":"($AS$76/30)*$AV$81^0.6667*AS$83^2.08","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Confined water formula",null,{"$f":"((6*$AS$81)+0.4)*$AS$76*AS$83*AS$83/100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Squat data in use",null,{"$f":"IF($AY$81>1.4,AS84,AS85)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"clearance at zero speed",null,{"$f":"IF($O$33-$G$21-$G$22<10,$O$33-$G$21-$G$22,10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data calculation for Tidal graph"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"time",null,null,"height",null,null,null,null,-2,-1.5,-1,-0.5,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HW",null,{"$f":"J23","v":"00:00:00"},null,null,{"$f":"M23","v":0},null,null,"time",null,{"$f":"$AS$95+($AS$97/10*BA94)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LW",null,{"$f":"J24","v":"00:00:00"},null,null,{"$f":"M24","v":0},null,null,"factor",null,{"$f":"(1-COS((180-180*BA94/10)*PI()/180))/2","v":0.90450849718747373},{"$f":"(1-COS((180-180*BB94/10)*PI()/180))/2","v":0.94550326209418412},{"$f":"(1-COS((180-180*BC94/10)*PI()/180))/2","v":0.97552825814757682},{"$f":"(1-COS((180-180*BD94/10)*PI()/180))/2","v":0.99384417029756889},{"$f":"(1-COS((180-180*BE94/10)*PI()/180))/2","v":1},0.99384417029756889,0.97552825814757682,0.94550326209418389,0.90450849718747373,0.85355339059327373,0.79389262614623646,0.72699524986977337,0.65450849718747373,0.57821723252011548,0.49999999999999994,0.42178276747988452,0.34549150281252627,0.27300475013022663,0.20610737385376343,0.14644660940672621,9.5491502812526274E-2,5.4496737905816051E-2,2.4471741852423234E-2,6.1558297024311148E-3,0,6.1558297024311148E-3,2.4471741852423234E-2,5.4496737905816051E-2,9.5491502812526274E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"range",null,{"$f":"AS96-AS95","v":"00:00:00"},null,null,{"$f":"AV95-AV96","v":0},null,null,"height",null,{"$f":"($AV$97*BA96)+$AV$96","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overhead clearance",null,null,null,"graph limit",null,10,null,"UKC",null,{"$f":"IF($O$19+$O$31-$G$33+BA$97<$AW$99,$O$19+$O$31-$G$33+BA$97,$AW$99)","v":0},{"$f":"IF($O$19+$O$31-$G$33+BB97<$AW$99,$O$19+$O$31-$G$33+BB97,$AW$99)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,{"$f":"IF($O$19+$O$31-$G$33+BA97-(0.1*$G$15)<$AW$99,$O$19+$O$31-$G$33+BA97-(0.1*$G$15),$AW$99)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$19+$O$31-$G$33+BA$97","v":0}]

{"sheet":"Air Draft","index":19,"n_rows":77,"n_cols":82,"rows_kept":77,"cut":false,"hidden":false,"merged":[[72,45,72,47],[53,2,53,6],[53,10,53,14],[19,9,19,11],[20,9,20,11],[1,4,1,12],[11,2,11,4],[71,45,71,47],[5,4,5,12],[3,4,3,12],[10,2,10,4],[10,7,10,9],[3,14,3,15],[2,14,2,15]]}
[]
[null,null,null,null,"HEALTH, SAFETY, ENVIRONMENT AND QUALITY MANAGEMENT",null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,"Overhead Clearance",null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[null,null,null,null,"SHIP REPORTING  FORMS  MANUAL"]
[]
[]
[]
[null,null,"Overhead restriction",null,null,null,null,"Passing time",null,null,null,null,null,null,"Overhead restriction"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Free Height ",null,"m"]
[null,null,null,null,null,null,null,"YYYY-MM-DD                      HH:MM",null,null,null,null,null,null,null,"m"]
[null,null,null,null,null,null,null,{"$f":"IF(AND($J$20<$H$11,$H$11<$J$21),\" \",\"'Passing time' does not match Tide data! \")","v":"'Passing time' does not match Tide data! "},null,null,null,null,null,"Safety margin",null,"m"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference height for overhead objects",{"$f":"IF(M20<M21,M21,M20)","v":0},"m"]
[null,null,null,null,null,"Ship's highest point above keel",{"$f":"Common!C36","v":0},"m"]
[]
[null,null,null,null,null,"Ships draft aft",{"$f":"'Arrival Port Info'!C22","v":0},"m"]
[null,null,null,null,null,null,null,null,null,"Tide          YYYY-MM-DD   HH:MM"]
[null,null,null,null,null,null,null,null,"Tide 1",{"$f":"'Arrival Tide'!F17","v":"00:00:00"},null,null,{"$f":"'Arrival Tide'!K17","v":0},"height"]
[null,null,null,null,null,null,null,null,"Tide 2",{"$f":"'Arrival Tide'!F22","v":"00:00:00"},null,null,{"$f":"'Arrival Tide'!K22","v":0},"height"]
[null,null,null,null,null,null,null,null,null,null,"Passing time",{"$f":"IF(J21>J20,H11-J20,J21-H11)","v":"00:00:00"},"hours"]
[null,null,null,null,null,null,null,null,null,null,"Tidal Duration",{"$f":"J21-J20","v":"00:00:00"},"hours","m"]
[null,null,null,null,null,null,null,null,null,null,"Factor (see note 2)",{"$f":"IF(L23=0,0,IF(M20<M21,1-(1-COS((180-180*L22/L23)*PI()/180))/2,(1-COS((180-180*L22/L23)*PI()/180))/2))","v":0},null,"m"]
[null,null,null,null,null,null,null,null,null,null,"Tidal Range",{"$f":"ABS(M20-M21)","v":0},"meters"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Height of tide",{"$f":"IF(M20<M21,(L24*L25)+M20,(L24*L25)+M21)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"height below reference",{"$f":"O15-M27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"height below reference",{"$f":"O15-M27","v":0},"m"]
[]
[]
[]
[null,null,null,null,null,"Ships air draft",{"$f":"G16-G18","v":0},"m",null,null,null,null,null,"Safe overhead clearance",{"$f":"O11-O13+O29","v":0},"m"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"O33","v":0},"m"]
[null,null,null,null,null,null,null,null,null,{"$f":"G33","v":0},"m"]
[]
[null,null,null,null,null,null,null,null,"Ship's safe overhead clearance ",{"$f":"J35-J36","v":0},"m"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2nd Officer",null,null,null,null,null,null,null,"Master"]
[]
[null,"(1) Entries may only be made in white cells; all others are protected."]
[null,"(2) The factor is automatically calculated, and this value may be used for ports outside N.W Europe."]
[null,"    In N.W. Europe, insert the the factor found in Admirality tide tables, graph for the appropriate standard port."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data calculation for Tidal graph"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"time",null,null,"height",null,null,null,null,-2,-1.5,-1,-0.5,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HW",null,{"$f":"J20","v":"00:00:00"},null,null,{"$f":"M20","v":0},null,null,"time",null,{"$f":"$AT$72+($AT$74/10*BB71)","v":"00:00:00"},{"$f":"$AT$72+($AT$74/10*BC71)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LW",null,{"$f":"J21","v":"00:00:00"},null,null,{"$f":"M21","v":0},null,null,"factor",null,{"$f":"(1-COS((180-180*BB71/10)*PI()/180))/2","v":0.90450849718747373},0.94550326209418412,0.97552825814757682,0.99384417029756889,1,0.99384417029756889,0.97552825814757682,0.94550326209418389,0.90450849718747373,0.85355339059327373,0.79389262614623646,0.72699524986977337,0.65450849718747373,0.57821723252011548,0.49999999999999994,0.42178276747988452,0.34549150281252627,0.27300475013022663,0.20610737385376343,0.14644660940672621,9.5491502812526274E-2,5.4496737905816051E-2,2.4471741852423234E-2,6.1558297024311148E-3,0,6.1558297024311148E-3,2.4471741852423234E-2,5.4496737905816051E-2,9.5491502812526274E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"range",null,{"$f":"AT73-AT72","v":"00:00:00"},null,null,{"$f":"AW72-AW73","v":0},null,null,"height",null,{"$f":"($AW$74*BB73)+$AW$73","v":0},{"$f":"($AW$74*BC73)+$AW$73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overhead clearance",null,null,null,"graph limit",null,20,null,null,null,{"$f":"IF($O$11-$O$13+$O$15-$G$33-BB74<$AX$76,$O$11-$O$13+$O$15-$G$33-BB74,$AX$76)","v":0},{"$f":"IF($O$11-$O$13+$O$15-$G$33-BC74<$AX$76,$O$11-$O$13+$O$15-$G$33-BC74,$AX$76)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($O$11+$O$15-$G$33-BB$74<$AX$76,$O$11+$O$15-$G$33-BB$74,$AX$76)","v":0},{"$f":"IF($O$11+$O$15-$G$33-BC$74<$AX$76,$O$11+$O$15-$G$33-BC$74,$AX$76)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Tide 1","index":20,"n_rows":76,"n_cols":79,"rows_kept":76,"cut":false,"hidden":false,"merged":[[73,42,73,44],[74,42,74,44],[10,3,10,6],[13,5,13,7],[16,5,16,7],[18,5,18,7],[21,5,21,7],[24,9,24,10],[1,3,1,9],[9,3,9,6],[3,3,3,9],[5,3,5,9],[8,3,8,6],[8,8,8,10]]}
[]
[null,null,null,"HEALTH, SAFETY, ENVIRONMENT AND QUALITY MANAGEMENT"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,null,"SIMPLIFIED TIDE CALCULATION",null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[]
[null,null,null,null,null,null,null,null,"YYYY-MM-DD  "]
[null,"Port",null,null,null,null,null,"Date: "]
[null,"Standard Port",null,null,null,null,null,"Time Zone: ",null,"hrs"]
[null,"Secondary Port"]
[null,"Tidal calculation"]
[null,null,null,null,null,"YYYY-MM-DD   HH:MM"]
[null,"Standard Port HW/LW date, time",null,null,null,null,null,null,null,"Height",null,"metres"]
[null,"Secondary Port differences (note 3)",null,null,null,"Time",null,null,null,"Height",null,"metres"]
[null,null,null,null,null,"YYYY-MM-DD   HH:MM"]
[null,"Secondary Port",null,"Date/Time",null,{"$f":"IF(G15>0,(F14+H15),(F14-H15))","v":"00:00:00"},null,null,null,"Height",{"$f":"SUM(K14:K15)","v":0},"metres"]
[null,null,null,null,null,"YYYY-MM-DD   HH:MM"]
[null,"Standard Port HW/LW date, time",null,null,null,null,null,null,null,"Height",null,"metres"]
[null,"Secondary Port differences (note 3)",null,null,null,"Time",null,null,null,"Height",null,"metres"]
[null,null,null,null,null,"YYYY-MM-DD   HH:MM"]
[null,"Secondary Port",null,"Date/Time",null,{"$f":"IF(G20>0,(F19+H20),(F19-H20))","v":"00:00:00"},null,null,null,"Height",{"$f":"K19+K20","v":0},"metres"]
[]
[null,"Tidal Range (HW Height - LW Height)",null,null,null,null,null,null,null,"Range",{"$f":"ABS(K17-K22)","v":0},"metres"]
[null,"Tidal Duration (HW Time ~ LW Time)",null,null,null,null,null,null,"Duration",{"$f":"ABS(F17-F22)","v":"00:00:00"},null,"Hours"]
[null,null,null,null,null,null,null,null,null,null,"DD HH:MM"]
[null,"(1) Entries may only be made in white cells; all others are protected."]
[null,"(3) For secondary port times, enter ' 1' for ' +' times and ' 0' for ' -' times "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data calculation for Tidal graph"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"time",null,null,"height",null,null,null,null,-2,-1.5,-1,-0.5,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HW",null,{"$f":"'Tide 1'!$F$17","v":"00:00:00"},null,null,{"$f":"'Tide 1'!$K$17","v":0},null,null,"time",null,{"$f":"$AQ$74+($AQ$76/10*AY73)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LW",null,{"$f":"'Tide 1'!$F$22","v":"00:00:00"},null,null,{"$f":"'Tide 1'!$K$22","v":0},null,null,"factor",null,{"$f":"(1-COS((180-180*AY73/10)*PI()/180))/2","v":0.90450849718747373},0.94550326209418412,0.97552825814757682,0.99384417029756889,1,0.99384417029756889,0.97552825814757682,0.94550326209418389,0.90450849718747373,0.85355339059327373,0.79389262614623646,0.72699524986977337,0.65450849718747373,0.57821723252011548,0.49999999999999994,0.42178276747988452,0.34549150281252627,0.27300475013022663,0.20610737385376343,0.14644660940672621,9.5491502812526274E-2,5.4496737905816051E-2,2.4471741852423234E-2,6.1558297024311148E-3,0,6.1558297024311148E-3,2.4471741852423234E-2,5.4496737905816051E-2,9.5491502812526274E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"range",null,{"$f":"'Tide 1'!J25","v":"00:00:00"},null,null,{"$f":"AT74-AT75","v":0},null,null,"height",null,{"$f":"($AT$76*AY75)+$AT$75","v":0},{"$f":"($AT$76*AZ75)+$AT$75","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"UKC Restricted 1","index":21,"n_rows":102,"n_cols":81,"rows_kept":102,"cut":false,"hidden":false,"merged":[[1,4,1,12],[95,44,95,46],[23,9,23,11],[5,4,5,12],[3,4,3,12],[18,2,18,4],[18,9,18,11],[64,2,64,6],[64,10,64,14],[22,9,22,11],[94,44,94,46],[3,14,3,15],[5,14,5,15]]}
[]
[null,null,null,null,"HEALTH, SAFETY, ENVIRONMENT AND QUALITY MANAGEMENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,null,null,"UKC - Under Keel Clearance -Restricted",null,null,null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,null,null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[]
[]
[null,null,null,"Heel/List",null,null,"Draft",null,null,null,null,null,null,null,"Depth reductions"]
[null,null,null,null,null,"Vessel's deepest draft:",null,"m",null,null,null,null,null,"Seasonal change",null,"m"]
[null,null,null,null,null,"Changes since departure",null,"m",null,null,null,null,null,"Storm surge or high pressure",null,"m"]
[null,null,null,null,null,"Change due to water density",null,"m",null,null,null,null,null,"Silting or land rise",null,"m"]
[null,null,null,null,null,"Draft increase due to List",{"$f":"TAN(RADIANS(E9))*Common!C33/2","v":0},"m",null,null,null,null,null,"Possible uncharted objects",null,"m"]
[]
[null,null,null,null,null,"Ships static draft",{"$f":"SUM(G10:G13)","v":0},"m",null,null,null,null,null,"Depth reductions",{"$f":"SUM(O10:O13)","v":0},"m"]
[]
[]
[null,null,"Critical location 1",null,null,null,null,null,null,"Passing time",null,null,null,null,"Charted depth"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m"]
[null,null,null,null,null,null,null,null,null,"YYYY-MM-DD                      HH:MM"]
[null,null,null,null,null,"Ships static draft",{"$f":"$G$15","v":0},"m",null,{"$f":"IF(AND($J$23<$J$19,$J$19<$J$24),\" \",\"'Passing time' does not match Tide data! \")","v":"'Passing time' does not match Tide data! "}]
[null,null,null,null,null,"Movements in sea and swell",null,"m",null,"Tide          YYYY-MM-DD   HH:MM"]
[null,null,null,null,null,null,null,null,"Tide 1",{"$f":"'Tide 1'!F17","v":"00:00:00"},null,null,{"$f":"'Tide 1'!K17","v":0},"m"]
[null,null,null,"Speed",null,"knots",null,null,"Tide 2",{"$f":"'Tide 1'!F22","v":"00:00:00"},null,null,{"$f":"'Tide 1'!K22","v":0},"m"]
[null,null,null,"Channel width",null,"m",null,null,null,null,"Passing time",{"$f":"IF(J24>J23,J19-J23,J24-J19)","v":"00:00:00"},"hours"]
[null,null,null,null,null,null,null,null,null,null,"Tidal Duration",{"$f":"J24-J23","v":"00:00:00"},"hours"]
[null,null,null,"Squat -open ",{"$f":"BE81","v":0},null,null,null,null,null,"Factor (see note 2)",{"$f":"IF(L26=0,0,IF(M23<M24,1-(1-COS((180-180*L25/L26)*PI()/180))/2,(1-COS((180-180*L25/L26)*PI()/180))/2))","v":0}]
[null,null,null,"Squat confined ",{"$f":"BG81","v":0},null,null,null,null,null,"Tidal Range",{"$f":"ABS(M23-M24)","v":0},"meters"]
[null,null,null,"D/d ",{"$f":"AY81","v":0},null,null,null,null,null,null,null,null,"Height of tide",{"$f":"IF(M23<M24,(L27*L28)+M23,(L27*L28)+M24)","v":0}]
[]
[null,null,null,"Squat in use",{"$f":"IF(E29>1.4,\"Open\",\"conf\")","v":"conf"},"Squat",{"$f":"'UKC Restricted 1'!BI81","v":0},"m",null,null,null,null,null,"depth reductions",{"$f":"$O$15","v":0},"m"]
[]
[null,null,null,null,null,"Ships dynamic draft",{"$f":"G21+G22+G31","v":0},"m",null,null,null,null,null,"Available depth",{"$f":"O19+O29+O31","v":0},"m"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"O33","v":0},"m"]
[null,null,null,null,null,null,null,null,null,{"$f":"G33","v":0},"m"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L38<10,\"Risk assessment required!\",\" \")","v":"Risk assessment required!"}]
[null,null,null,null,null,null,null,null,"UKC under keel clearance ",{"$f":"J35-J36","v":0},"m",{"$f":"IF($G$33=0,0,J38/$G$33*100)","v":0},"% of deepest draught"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2nd Officer",null,null,null,null,null,null,null,"Master"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data for calculating Squat graph"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Block",null,{"$f":"cb","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'UKC Restricted 1'!C19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S=As/Ac",{"$f":"IF($O$33=0,0,IF($E$25=0,0,G10*Common!C33/$O$33/$E$25))","v":0},null,"S2=S/(1-S)",{"$f":"AS81/(1-AS81)","v":0},null,"d/D",{"$f":"IF($G$15=0,0,$O$33/$G$15)","v":0},null,"Shallow/Open?",{"$f":"IF(AY81>1.4,\"Open\",\"Shallow\")","v":"Shallow"},null,"Squat OW",{"$f":"($AS$76/30)*$AV$81^0.6667*$E$24^2.08","v":0},"Squat CW",{"$f":"((6*$AS$81)+0.4)*$AS$76*$E$24^2/100","v":0},"In use",{"$f":"IF($AY$81>1.4,$BE$81,$BG$81)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"speed",null,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,12.5,13,13.5,14,14.5,15,15.5,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open water formula",null,{"$f":"($AS$76/30)*$AV$81^0.6667*AS$83^2.08","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Confined water formula",null,{"$f":"((6*$AS$81)+0.4)*$AS$76*AS$83*AS$83/100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Squat data in use",null,{"$f":"IF($AY$81>1.4,AS84,AS85)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"clearance at zero speed",null,{"$f":"IF($O$33-$G$21-$G$22<10,$O$33-$G$21-$G$22,10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data calculation for Tidal graph"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"time",null,null,"height",null,null,null,null,-2,-1.5,-1,-0.5,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HW",null,{"$f":"J23","v":"00:00:00"},null,null,{"$f":"M23","v":0},null,null,"time",null,{"$f":"$AS$95+($AS$97/10*BA94)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LW",null,{"$f":"J24","v":"00:00:00"},null,null,{"$f":"M24","v":0},null,null,"factor",null,{"$f":"(1-COS((180-180*BA94/10)*PI()/180))/2","v":0.90450849718747373},{"$f":"(1-COS((180-180*BB94/10)*PI()/180))/2","v":0.94550326209418412},{"$f":"(1-COS((180-180*BC94/10)*PI()/180))/2","v":0.97552825814757682},{"$f":"(1-COS((180-180*BD94/10)*PI()/180))/2","v":0.99384417029756889},{"$f":"(1-COS((180-180*BE94/10)*PI()/180))/2","v":1},0.99384417029756889,0.97552825814757682,0.94550326209418389,0.90450849718747373,0.85355339059327373,0.79389262614623646,0.72699524986977337,0.65450849718747373,0.57821723252011548,0.49999999999999994,0.42178276747988452,0.34549150281252627,0.27300475013022663,0.20610737385376343,0.14644660940672621,9.5491502812526274E-2,5.4496737905816051E-2,2.4471741852423234E-2,6.1558297024311148E-3,0,6.1558297024311148E-3,2.4471741852423234E-2,5.4496737905816051E-2,9.5491502812526274E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"range",null,{"$f":"AS96-AS95","v":"00:00:00"},null,null,{"$f":"AV95-AV96","v":0},null,null,"height",null,{"$f":"($AV$97*BA96)+$AV$96","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overhead clearance",null,null,null,"graph limit",null,10,null,"UKC",null,{"$f":"IF($O$19+$O$31-$G$33+BA$97<$AW$99,$O$19+$O$31-$G$33+BA$97,$AW$99)","v":0},{"$f":"IF($O$19+$O$31-$G$33+BB97<$AW$99,$O$19+$O$31-$G$33+BB97,$AW$99)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,{"$f":"IF($O$19+$O$31-$G$33+BA97-(0.1*$G$15)<$AW$99,$O$19+$O$31-$G$33+BA97-(0.1*$G$15),$AW$99)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$19+$O$31-$G$33+BA$97","v":0}]

{"sheet":"Air Draft 1","index":22,"n_rows":77,"n_cols":82,"rows_kept":77,"cut":false,"hidden":false,"merged":[[72,45,72,47],[11,2,11,4],[19,9,19,11],[20,9,20,11],[53,2,53,6],[53,10,53,14],[71,45,71,47],[1,4,1,12],[3,4,3,12],[3,14,3,15],[5,4,5,12],[10,2,10,4],[10,7,10,9]]}
[]
[null,null,null,null,"HEALTH, SAFETY, ENVIRONMENT AND QUALITY MANAGEMENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,null,null,"Overhead Clearance",null,null,null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,null,null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[]
[]
[]
[null,null,"Overhead restriction",null,null,null,null,"Passing time",null,null,null,null,null,null,"Overhead restriction"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Free Height ",null,"m"]
[null,null,null,null,null,null,null,"YYYY-MM-DD                      HH:MM",null,null,null,null,null,null,null,"m"]
[null,null,null,null,null,null,null,{"$f":"IF(AND($J$20<$H$11,$H$11<$J$21),\" \",\"'Passing time' does not match Tide data! \")","v":"'Passing time' does not match Tide data! "},null,null,null,null,null,"Safety margin",null,"m"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference height for overhead objects",{"$f":"IF(M20<M21,M21,M20)","v":0},"m"]
[null,null,null,null,null,"Ship's highest point above keel",{"$f":"Common!C36","v":0},"m"]
[]
[null,null,null,null,null,"Ships draft aft",null,"m"]
[null,null,null,null,null,null,null,null,null,"Tide          YYYY-MM-DD   HH:MM"]
[null,null,null,null,null,null,null,null,"Tide 1",{"$f":"'Tide 1'!F17","v":"00:00:00"},null,null,{"$f":"'Tide 1'!K17","v":0},"height"]
[null,null,null,null,null,null,null,null,"Tide 2",{"$f":"'Tide 1'!F22","v":"00:00:00"},null,null,{"$f":"'Tide 1'!K22","v":0},"height"]
[null,null,null,null,null,null,null,null,null,null,"Passing time",{"$f":"IF(J21>J20,H11-J20,J21-H11)","v":"00:00:00"},"hours"]
[null,null,null,null,null,null,null,null,null,null,"Tidal Duration",{"$f":"J21-J20","v":"00:00:00"},"hours","m"]
[null,null,null,null,null,null,null,null,null,null,"Factor (see note 2)",{"$f":"IF(L23=0,0,IF(M20<M21,1-(1-COS((180-180*L22/L23)*PI()/180))/2,(1-COS((180-180*L22/L23)*PI()/180))/2))","v":0},null,"m"]
[null,null,null,null,null,null,null,null,null,null,"Tidal Range",{"$f":"ABS(M20-M21)","v":0},"meters"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Height of tide",{"$f":"IF(M20<M21,(L24*L25)+M20,(L24*L25)+M21)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"height below reference",{"$f":"O15-M27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"height below reference",{"$f":"O15-M27","v":0},"m"]
[]
[]
[]
[null,null,null,null,null,"Ships air draft",{"$f":"G16-G18","v":0},"m",null,null,null,null,null,"Safe overhead clearance",{"$f":"O11-O13+O29","v":0},"m"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"O33","v":0},"m"]
[null,null,null,null,null,null,null,null,null,{"$f":"G33","v":0},"m"]
[]
[null,null,null,null,null,null,null,null,"Ship's safe overhead clearance ",{"$f":"J35-J36","v":0},"m"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2nd Officer",null,null,null,null,null,null,null,"Master"]
[]
[null,"(1) Entries may only be made in white cells; all others are protected."]
[null,"(2) The factor is automatically calculated, and this value may be used for ports outside N.W Europe."]
[null,"    In N.W. Europe, insert the the factor found in Admirality tide tables, graph for the appropriate standard port."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data calculation for Tidal graph"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"time",null,null,"height",null,null,null,null,-2,-1.5,-1,-0.5,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HW",null,{"$f":"J20","v":"00:00:00"},null,null,{"$f":"M20","v":0},null,null,"time",null,{"$f":"$AT$72+($AT$74/10*BB71)","v":"00:00:00"},{"$f":"$AT$72+($AT$74/10*BC71)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LW",null,{"$f":"J21","v":"00:00:00"},null,null,{"$f":"M21","v":0},null,null,"factor",null,{"$f":"(1-COS((180-180*BB71/10)*PI()/180))/2","v":0.90450849718747373},0.94550326209418412,0.97552825814757682,0.99384417029756889,1,0.99384417029756889,0.97552825814757682,0.94550326209418389,0.90450849718747373,0.85355339059327373,0.79389262614623646,0.72699524986977337,0.65450849718747373,0.57821723252011548,0.49999999999999994,0.42178276747988452,0.34549150281252627,0.27300475013022663,0.20610737385376343,0.14644660940672621,9.5491502812526274E-2,5.4496737905816051E-2,2.4471741852423234E-2,6.1558297024311148E-3,0,6.1558297024311148E-3,2.4471741852423234E-2,5.4496737905816051E-2,9.5491502812526274E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"range",null,{"$f":"AT73-AT72","v":"00:00:00"},null,null,{"$f":"AW72-AW73","v":0},null,null,"height",null,{"$f":"($AW$74*BB73)+$AW$73","v":0},{"$f":"($AW$74*BC73)+$AW$73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overhead clearance",null,null,null,"graph limit",null,20,null,null,null,{"$f":"IF($O$11-$O$13+$O$15-$G$33-BB74<$AX$76,$O$11-$O$13+$O$15-$G$33-BB74,$AX$76)","v":0},{"$f":"IF($O$11-$O$13+$O$15-$G$33-BC74<$AX$76,$O$11-$O$13+$O$15-$G$33-BC74,$AX$76)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($O$11+$O$15-$G$33-BB$74<$AX$76,$O$11+$O$15-$G$33-BB$74,$AX$76)","v":0},{"$f":"IF($O$11+$O$15-$G$33-BC$74<$AX$76,$O$11+$O$15-$G$33-BC$74,$AX$76)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Tide 2","index":23,"n_rows":76,"n_cols":79,"rows_kept":76,"cut":false,"hidden":false,"merged":[[74,42,74,44],[10,3,10,6],[13,5,13,7],[16,5,16,7],[18,5,18,7],[21,5,21,7],[24,9,24,10],[3,11,3,12],[5,3,5,9],[8,3,8,6],[8,8,8,10],[73,42,73,44],[1,3,1,9],[2,3,2,9],[4,3,4,9],[9,3,9,6],[3,3,3,9]]}
[]
[null,null,null,"HEALTH, SAFETY, ENVIRONMENT AND QUALITY MANAGEMENT"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,null,"SIMPLIFIED TIDE CALCULATION",null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[]
[null,null,null,null,null,null,null,null,"YYYY-MM-DD  "]
[null,"Port",null,null,null,null,null,"Date: "]
[null,"Standard Port",null,null,null,null,null,"Time Zone: ",null,"hrs"]
[null,"Secondary Port"]
[null,"Tidal calculation"]
[null,null,null,null,null,"YYYY-MM-DD   HH:MM"]
[null,"Standard Port HW/LW date, time",null,null,null,null,null,null,null,"Height",null,"metres"]
[null,"Secondary Port differences (note 3)",null,null,null,"Time",null,null,null,"Height",null,"metres"]
[null,null,null,null,null,"YYYY-MM-DD   HH:MM"]
[null,"Secondary Port",null,"Date/Time",null,{"$f":"IF(G15>0,(F14+H15),(F14-H15))","v":"00:00:00"},null,null,null,"Height",{"$f":"SUM(K14:K15)","v":0},"metres"]
[null,null,null,null,null,"YYYY-MM-DD   HH:MM"]
[null,"Standard Port HW/LW date, time",null,null,null,null,null,null,null,"Height",null,"metres"]
[null,"Secondary Port differences (note 3)",null,null,null,"Time",null,null,null,"Height",null,"metres"]
[null,null,null,null,null,"YYYY-MM-DD   HH:MM"]
[null,"Secondary Port",null,"Date/Time",null,{"$f":"IF(G20>0,(F19+H20),(F19-H20))","v":"00:00:00"},null,null,null,"Height",{"$f":"K19+K20","v":0},"metres"]
[]
[null,"Tidal Range (HW Height - LW Height)",null,null,null,null,null,null,null,"Range",{"$f":"ABS(K17-K22)","v":0},"metres"]
[null,"Tidal Duration (HW Time ~ LW Time)",null,null,null,null,null,null,"Duration",{"$f":"ABS(F17-F22)","v":"00:00:00"},null,"Hours"]
[null,null,null,null,null,null,null,null,null,null,"DD HH:MM"]
[null,"(1) Entries may only be made in white cells; all others are protected."]
[null,"(3) For secondary port times, enter ' 1' for ' +' times and ' 0' for ' -' times "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data calculation for Tidal graph"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"time",null,null,"height",null,null,null,null,-2,-1.5,-1,-0.5,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HW",null,{"$f":"'Tide 2'!$F$17","v":"00:00:00"},null,null,{"$f":"'Tide 2'!$K$17","v":0},null,null,"time",null,{"$f":"$AQ$74+($AQ$76/10*AY73)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LW",null,{"$f":"'Tide 2'!$F$22","v":"00:00:00"},null,null,{"$f":"'Tide 2'!$K$22","v":0},null,null,"factor",null,{"$f":"(1-COS((180-180*AY73/10)*PI()/180))/2","v":0.90450849718747373},0.94550326209418412,0.97552825814757682,0.99384417029756889,1,0.99384417029756889,0.97552825814757682,0.94550326209418389,0.90450849718747373,0.85355339059327373,0.79389262614623646,0.72699524986977337,0.65450849718747373,0.57821723252011548,0.49999999999999994,0.42178276747988452,0.34549150281252627,0.27300475013022663,0.20610737385376343,0.14644660940672621,9.5491502812526274E-2,5.4496737905816051E-2,2.4471741852423234E-2,6.1558297024311148E-3,0,6.1558297024311148E-3,2.4471741852423234E-2,5.4496737905816051E-2,9.5491502812526274E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"range",null,{"$f":"'Tide 2'!J25","v":"00:00:00"},null,null,{"$f":"AT74-AT75","v":0},null,null,"height",null,{"$f":"($AT$76*AY75)+$AT$75","v":0},{"$f":"($AT$76*AZ75)+$AT$75","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"UKC Restricted 2","index":24,"n_rows":102,"n_cols":81,"rows_kept":102,"cut":false,"hidden":false,"merged":[[3,14,3,15],[95,44,95,46],[23,9,23,11],[64,2,64,6],[64,10,64,14],[18,2,18,4],[18,9,18,11],[22,9,22,11],[94,44,94,46],[36,11,36,14],[1,4,1,12],[2,4,2,12],[4,4,4,12],[5,4,5,12],[3,4,3,12]]}
[]
[null,null,null,null,"HEALTH, SAFETY, ENVIRONMENT AND QUALITY MANAGEMENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,null,null,"UKC - Under Keel Clearance -Restricted",null,null,null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,null,null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[]
[]
[null,null,null,"Heel/List",null,null,"Draft",null,null,null,null,null,null,null,"Depth reductions"]
[null,null,null,null,null,"Vessel's deepest draft:",null,"m",null,null,null,null,null,"Seasonal change",null,"m"]
[null,null,null,null,null,"Changes since departure",null,"m",null,null,null,null,null,"Storm surge or high pressure",null,"m"]
[null,null,null,null,null,"Change due to water density",null,"m",null,null,null,null,null,"Silting or land rise",null,"m"]
[null,null,null,null,null,"Draft increase due to List",{"$f":"TAN(RADIANS(E9))*Common!C33/2","v":0},"m",null,null,null,null,null,"Possible uncharted objects",null,"m"]
[]
[null,null,null,null,null,"Ships static draft",{"$f":"SUM(G10:G13)","v":0},"m",null,null,null,null,null,"Depth reductions",{"$f":"SUM(O10:O13)","v":0},"m"]
[]
[]
[null,null,"Critical location 2",null,null,null,null,null,null,"Passing time",null,null,null,null,"Charted depth"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m"]
[null,null,null,null,null,null,null,null,null,"YYYY-MM-DD                      HH:MM"]
[null,null,null,null,null,"Ships static draft",{"$f":"$G$15","v":0},"m",null,{"$f":"IF(AND($J$23<$J$19,$J$19<$J$24),\" \",\"'Passing time' does not match Tide data! \")","v":"'Passing time' does not match Tide data! "}]
[null,null,null,null,null,"Movements in sea and swell",null,"m",null,"Tide          YYYY-MM-DD   HH:MM"]
[null,null,null,null,null,null,null,null,"Tide 1",{"$f":"'Tide 2'!F17","v":"00:00:00"},null,null,{"$f":"'Tide 2'!K17","v":0},"m"]
[null,null,null,"Speed",null,"knots",null,null,"Tide 2",{"$f":"'Tide 2'!F22","v":"00:00:00"},null,null,{"$f":"'Tide 2'!K22","v":0},"m"]
[null,null,null,"Channel width",null,"m",null,null,null,null,"Passing time",{"$f":"IF(J24>J23,J19-J23,J24-J19)","v":"00:00:00"},"hours"]
[null,null,null,null,null,null,null,null,null,null,"Tidal Duration",{"$f":"J24-J23","v":"00:00:00"},"hours"]
[null,null,null,"Squat -open ",{"$f":"BE81","v":0},null,null,null,null,null,"Factor (see note 2)",{"$f":"IF(L26=0,0,IF(M23<M24,1-(1-COS((180-180*L25/L26)*PI()/180))/2,(1-COS((180-180*L25/L26)*PI()/180))/2))","v":0}]
[null,null,null,"Squat confined ",{"$f":"BG81","v":0},null,null,null,null,null,"Tidal Range",{"$f":"ABS(M23-M24)","v":0},"meters"]
[null,null,null,"D/d ",{"$f":"AY81","v":0},null,null,null,null,null,null,null,null,"Height of tide",{"$f":"IF(M23<M24,(L27*L28)+M23,(L27*L28)+M24)","v":0}]
[]
[null,null,null,"Squat in use",{"$f":"IF(E29>1.4,\"Open\",\"conf\")","v":"conf"},"Squat",{"$f":"'UKC Restricted 2'!BI81","v":0},"m",null,null,null,null,null,"depth reductions",{"$f":"$O$15","v":0},"m"]
[]
[null,null,null,null,null,"Ships dynamic draft",{"$f":"G21+G22+G31","v":0},"m",null,null,null,null,null,"Available depth",{"$f":"O19+O29+O31","v":0},"m"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"O33","v":0},"m"]
[null,null,null,null,null,null,null,null,null,{"$f":"G33","v":0},"m"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L38<10,\"Risk assessment required!\",\" \")","v":"Risk assessment required!"}]
[null,null,null,null,null,null,null,null,"UKC under keel clearance ",{"$f":"J35-J36","v":0},"m",{"$f":"IF($G$33=0,0,J38/$G$33*100)","v":0},"% of deepest draught"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2nd Officer",null,null,null,null,null,null,null,"Master"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data for calculating Squat graph"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Block",null,{"$f":"cb","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'UKC Restricted 2'!C19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S=As/Ac",{"$f":"IF($O$33=0,0,IF($E$25=0,0,G10*Common!C33/$O$33/$E$25))","v":0},null,"S2=S/(1-S)",{"$f":"AS81/(1-AS81)","v":0},null,"d/D",{"$f":"IF($G$15=0,0,$O$33/$G$15)","v":0},null,"Shallow/Open?",{"$f":"IF(AY81>1.4,\"Open\",\"Shallow\")","v":"Shallow"},null,"Squat OW",{"$f":"($AS$76/30)*$AV$81^0.6667*$E$24^2.08","v":0},"Squat CW",{"$f":"((6*$AS$81)+0.4)*$AS$76*$E$24^2/100","v":0},"In use",{"$f":"IF($AY$81>1.4,$BE$81,$BG$81)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"speed",null,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,12.5,13,13.5,14,14.5,15,15.5,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open water formula",null,{"$f":"($AS$76/30)*$AV$81^0.6667*AS$83^2.08","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Confined water formula",null,{"$f":"((6*$AS$81)+0.4)*$AS$76*AS$83*AS$83/100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Squat data in use",null,{"$f":"IF($AY$81>1.4,AS84,AS85)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"clearance at zero speed",null,{"$f":"IF($O$33-$G$21-$G$22<10,$O$33-$G$21-$G$22,10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data calculation for Tidal graph"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"time",null,null,"height",null,null,null,null,-2,-1.5,-1,-0.5,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HW",null,{"$f":"J23","v":"00:00:00"},null,null,{"$f":"M23","v":0},null,null,"time",null,{"$f":"$AS$95+($AS$97/10*BA94)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LW",null,{"$f":"J24","v":"00:00:00"},null,null,{"$f":"M24","v":0},null,null,"factor",null,{"$f":"(1-COS((180-180*BA94/10)*PI()/180))/2","v":0.90450849718747373},0.94550326209418412,0.97552825814757682,0.99384417029756889,1,0.99384417029756889,0.97552825814757682,0.94550326209418389,0.90450849718747373,0.85355339059327373,0.79389262614623646,0.72699524986977337,0.65450849718747373,0.57821723252011548,0.49999999999999994,0.42178276747988452,0.34549150281252627,0.27300475013022663,0.20610737385376343,0.14644660940672621,9.5491502812526274E-2,5.4496737905816051E-2,2.4471741852423234E-2,6.1558297024311148E-3,0,6.1558297024311148E-3,2.4471741852423234E-2,5.4496737905816051E-2,9.5491502812526274E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"range",null,{"$f":"AS96-AS95","v":"00:00:00"},null,null,{"$f":"AV95-AV96","v":0},null,null,"height",null,{"$f":"($AV$97*BA96)+$AV$96","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overhead clearance",null,null,null,"graph limit",null,10,null,"UKC",null,{"$f":"IF($O$19+$O$31-$G$33+BA$97<$AW$99,$O$19+$O$31-$G$33+BA$97,$AW$99)","v":0},{"$f":"IF($O$19+$O$31-$G$33+BB97<$AW$99,$O$19+$O$31-$G$33+BB97,$AW$99)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,{"$f":"IF($O$19+$O$31-$G$33+BA97-(0.1*$G$15)<$AW$99,$O$19+$O$31-$G$33+BA97-(0.1*$G$15),$AW$99)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$19+$O$31-$G$33+BA$97","v":0}]

{"sheet":"Air Draft 2","index":25,"n_rows":77,"n_cols":82,"rows_kept":77,"cut":false,"hidden":false,"merged":[[72,45,72,47],[11,2,11,4],[19,9,19,11],[20,9,20,11],[53,2,53,6],[53,10,53,14],[71,45,71,47],[1,4,1,12],[3,4,3,12],[3,14,3,15],[5,4,5,12],[10,2,10,4],[10,7,10,9]]}
[]
[null,null,null,null,"HEALTH, SAFETY, ENVIRONMENT AND QUALITY MANAGEMENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,null,null,null,"Overhead Clearance",null,null,null,null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,null,null,null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[]
[]
[]
[null,null,"Overhead restriction",null,null,null,null,"Passing time",null,null,null,null,null,null,"Overhead restriction"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Free Height ",null,"m"]
[null,null,null,null,null,null,null,"YYYY-MM-DD                      HH:MM",null,null,null,null,null,null,null,"m"]
[null,null,null,null,null,null,null,{"$f":"IF(AND($J$20<$H$11,$H$11<$J$21),\" \",\"'Passing time' does not match Tide data! \")","v":"'Passing time' does not match Tide data! "},null,null,null,null,null,"Safety margin",null,"m"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference height for overhead objects",{"$f":"IF(M20<M21,M21,M20)","v":0},"m"]
[null,null,null,null,null,"Ship's highest point above keel",{"$f":"Common!C36","v":0},"m"]
[]
[null,null,null,null,null,"Ships draft aft",null,"m"]
[null,null,null,null,null,null,null,null,null,"Tide          YYYY-MM-DD   HH:MM"]
[null,null,null,null,null,null,null,null,"Tide 1",{"$f":"'Tide 2'!F17","v":"00:00:00"},null,null,{"$f":"'Tide 2'!K17","v":0},"height"]
[null,null,null,null,null,null,null,null,"Tide 2",{"$f":"'Tide 2'!F22","v":"00:00:00"},null,null,{"$f":"'Tide 2'!K22","v":0},"height"]
[null,null,null,null,null,null,null,null,null,null,"Passing time",{"$f":"IF(J21>J20,H11-J20,J21-H11)","v":"00:00:00"},"hours"]
[null,null,null,null,null,null,null,null,null,null,"Tidal Duration",{"$f":"J21-J20","v":"00:00:00"},"hours","m"]
[null,null,null,null,null,null,null,null,null,null,"Factor (see note 2)",{"$f":"IF(L23=0,0,IF(M20<M21,1-(1-COS((180-180*L22/L23)*PI()/180))/2,(1-COS((180-180*L22/L23)*PI()/180))/2))","v":0},null,"m"]
[null,null,null,null,null,null,null,null,null,null,"Tidal Range",{"$f":"ABS(M20-M21)","v":0},"meters"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Height of tide",{"$f":"IF(M20<M21,(L24*L25)+M20,(L24*L25)+M21)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"height below reference",{"$f":"O15-M27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"height below reference",{"$f":"O15-M27","v":0},"m"]
[]
[]
[]
[null,null,null,null,null,"Ships air draft",{"$f":"G16-G18","v":0},"m",null,null,null,null,null,"Safe overhead clearance",{"$f":"O11-O13+O29","v":0},"m"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"O33","v":0},"m"]
[null,null,null,null,null,null,null,null,null,{"$f":"G33","v":0},"m"]
[]
[null,null,null,null,null,null,null,null,"Ship's safe overhead clearance ",{"$f":"J35-J36","v":0},"m"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2nd Officer",null,null,null,null,null,null,null,"Master"]
[]
[null,"(1) Entries may only be made in white cells; all others are protected."]
[null,"(2) The factor is automatically calculated, and this value may be used for ports outside N.W Europe."]
[null,"    In N.W. Europe, insert the the factor found in Admirality tide tables, graph for the appropriate standard port."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data calculation for Tidal graph"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"time",null,null,"height",null,null,null,null,-2,-1.5,-1,-0.5,0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HW",null,{"$f":"J20","v":"00:00:00"},null,null,{"$f":"M20","v":0},null,null,"time",null,{"$f":"$AT$72+($AT$74/10*BB71)","v":"00:00:00"},{"$f":"$AT$72+($AT$74/10*BC71)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LW",null,{"$f":"J21","v":"00:00:00"},null,null,{"$f":"M21","v":0},null,null,"factor",null,{"$f":"(1-COS((180-180*BB71/10)*PI()/180))/2","v":0.90450849718747373},0.94550326209418412,0.97552825814757682,0.99384417029756889,1,0.99384417029756889,0.97552825814757682,0.94550326209418389,0.90450849718747373,0.85355339059327373,0.79389262614623646,0.72699524986977337,0.65450849718747373,0.57821723252011548,0.49999999999999994,0.42178276747988452,0.34549150281252627,0.27300475013022663,0.20610737385376343,0.14644660940672621,9.5491502812526274E-2,5.4496737905816051E-2,2.4471741852423234E-2,6.1558297024311148E-3,0,6.1558297024311148E-3,2.4471741852423234E-2,5.4496737905816051E-2,9.5491502812526274E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"range",null,{"$f":"AT73-AT72","v":"00:00:00"},null,null,{"$f":"AW72-AW73","v":0},null,null,"height",null,{"$f":"($AW$74*BB73)+$AW$73","v":0},{"$f":"($AW$74*BC73)+$AW$73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overhead clearance",null,null,null,"graph limit",null,20,null,null,null,{"$f":"IF($O$11-$O$13+$O$15-$G$33-BB74<$AX$76,$O$11-$O$13+$O$15-$G$33-BB74,$AX$76)","v":0},{"$f":"IF($O$11-$O$13+$O$15-$G$33-BC74<$AX$76,$O$11-$O$13+$O$15-$G$33-BC74,$AX$76)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($O$11+$O$15-$G$33-BB$74<$AX$76,$O$11+$O$15-$G$33-BB$74,$AX$76)","v":0},{"$f":"IF($O$11+$O$15-$G$33-BC$74<$AX$76,$O$11+$O$15-$G$33-BC$74,$AX$76)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Post Voyage Review","index":26,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[9,0,9,8],[0,1,1,6],[2,1,3,6],[4,1,5,6],[7,0,7,8],[8,0,8,8],[21,0,21,8],[10,0,10,8],[11,0,11,8],[12,0,12,8],[13,0,13,8],[14,0,14,8],[15,0,15,8],[16,0,16,8],[17,0,17,8],[18,0,18,8],[19,0,19,8],[20,0,20,8],[22,0,22,8],[23,0,23,8],[24,0,24,8],[25,0,25,8],[26,0,26,8],[32,6,32,7],[31,6,31,7],[29,6,29,7],[28,6,28,7],[32,1,32,2],[31,1,31,2],[29,1,29,2],[28,1,28,2]]}
[null,"HEALTH, SAFETY,  ENVIRONMENT AND QUALITY MANAGEMENT SYSTEM"]
[null,null,null,null,null,null,null,{"$f":"Common!E2","v":"Form"},{"$f":"Common!F2","v":"1.3.1"}]
[null,"PASSAGE PLAN - POST VOYAGE REVIEW",null,null,null,null,null,{"$f":"Common!E3","v":"Date:"},{"$f":"Common!F3","v":"08-Aug-2025"}]
[null,null,null,null,null,null,null,{"$f":"Common!E4","v":"Rev No."},{"$f":"Common!F4","v":"10.1"}]
[null,"SHIP REPORTING  FORMS  MANUAL",null,null,null,null,null,{"$f":"Common!E5","v":"Appr:"},{"$f":"Common!F5","v":"DPA"}]
[null,null,null,null,null,null,null,{"$f":"Common!E6","v":"File No."},{"$f":"Common!F6","v":"1.3"}]
[]
["PASSAGE PLAN - POST VOYAGE REVIEW "]
["Bridge Team to carry out the review of the passage plan after completion of the voyage. It may include any hazards or useful information discovered that can be incorporated into future passage plan e.g.  the near miss/non-conformity/incident related to navigation encountered during the voyage, unexpected vessel traffic, fishing vessel / net concentration, military exercise or other nav warnings encountered and action taken, issues with UKC, visibility and additional watch keeper requirements, issues with pilotage, tug requirements, fendering requirements, TSS issues, any special navigation requirements from port."]
["Review Comments:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Master:",null,null,null,null,"2NO:"]
["Signature:",null,null,null,null,"Signature:"]
[]
["CNO:",null,null,null,null,"3NO:"]
["Signature:",null,null,null,null,"Signature:"]

{"sheet":"Pick List","index":27,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
["Fix Freq Sea","Fix Frequency Port","Fix Method","Sailing","Load Condition","Watch Level","Lat","Long","Yes/No"]
["<6 m","<6 m ","Vis","RL","Ballast",1,"N","E","Yes"]
["<9 m","<12 m","Rdr","GC","Partly Loaded",2,"S","W","No"]
["<12 m","<18 m","Cel",null,"Loaded",3]
["<18 m","<24 m","GPS",null,null,4]
["<24 m","<30 m","DR",null,null,5]
["<30 m","<60 m"]
["<60 m","<2 Hrs"]
["<2 Hrs"]
["<4 Hrs"]

{"sheet":"Sheet1","index":28,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}